Navigation Subform Combobox

[jamescullis]

I've got a subform that has a filtered combo box based on another combo box and are getting a parameter error on loading the form through the Navigation Form.

Main Form = ProjectMain
SubForm = ProjectDetails
Combo Box = CompanyIDcbo

I've tried the below combinations to get it to work but no luck. Any help would be appreciated.


[Forms]![ProjectsMain]![ProjectDetails].[Form]![CompanyIDcbo]
[Forms]![ProjectsMain]![NavigationSubform].[Form]![ProjectDetails].[CompanyIDcbo]
[Forms]![ProjectsMain]![NavigationSubform].[Form]![ProjectDetails].[Form].[CompanyIDcbo]
[Forms]![ProjectsMain]![NavigationSubform].[Form]![ProjectDetails].[Form]![CompanyIDcbo]

 

[pr2-eugin]

It depends on where it is called from. From your description this is unclear.

 

[jamescullis]

It depends on where it is called from. From your description this is unclear.

I've attached a screenshoot which shows the ProjectDetails subform, the arrow is indicating the field, PrimaryStakeHoldercbo

the combo above that is the the problem - CompanyIDcbo

in CompanyIDcbo I've set the Event AfterUpdate to requery PrimaryStakeHoldercbo

in PrimaryStakeHolder I previously had the Criteria for CompanyID field set to [Forms]![ProjectDetailsfrm]![CompanyIDcbo], however this won't work within the SubForm of a Navigation Form.

I hope this explains it better.

 

[jamescullis]

Did the above make more sense?

 

[spikepl]

On the form where you are going to use the reference to another control create a textbox. In the Control Source property, click on the ellipses and choose Expression Builder. There navigate to the control of interest, and click Paste. Now you have an expression for referring to that control from your current location which you can copy.