Row Source Query in Navigation Subform

[abcrf]

Hi all,

I have a combo box with the following row source:

SELECT distinct TBL_PROTOCOL.[PROTOCOL NUMBER] FROM TBL_PROTOCOL WHERE (([STUDY NAME]=Forms.FRM_PROTOCOL.SetStudy)) ORDER BY TBL_PROTOCOL.[PROTOCOL NUMBER];

It works completely fine in the form itself, but when the form is accessed via the navigation subform that users will use to access it, it stops working, and instead prompts me for a value of Forms.FRM_PROTOCOL.SetStudy.

I can't find anything on the web about how to refer to forms within a navigation subform. Can anyone tell me how I need to tweak the syntax to allow this to work in the overall navigation structure?

Thanks!!

 

[leanpilar]

because your query criteria call the form FRM_PROTOCOL not the navigationsubform on the main form.
try:
your [STUDY NAME] = Forms!Mainform.navigationsubformName.navigationsubform.form.SetStudy
not sure but it is something like this

 

[abcrf]

I'm not 100% sure I understand the distinction between "navigationsubformName" and "navigationsub form"

I tried the following, but it doesn't resolve the issue.

[STUDY NAME]=Forms!NAV_DATABASE.NavigationControl0.FRM_PROTOCOL.Form.SetStudy)

 

[leanpilar]

navigationsubformname is the name of yout object on the form. the navigationsubform is the subform in the navigtionsubform object


[STUDY NAME]=Forms!NAV_DATABASE.NavigationControl0.navigationsubform.Form.SetStudy)

Sent from my SM-G930F using Tapatalk

 

[abcrf]

Still getting the same error message:

"Enter Parameter Value: Forms!NAV_DATABASE.NavigationControl0.NavigationSubform.Form.SetStudy"

 

[leanpilar]

it's hard witout see your database. I use the immediate window to test all that string with the form open to see if work. if you use the navigationcontro on a normal form the sintax is near that.

Sent from my SM-G930F using Tapatalk