By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,238 Members | 1,659 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,238 IT Pros & Developers. It's quick & easy.

Cascading Combo box on subform

P: 1
Hi,
I have a form called EquipmentADD/EDIT with a sub form FIPinfoADD/EDIT.
I put cascading combo boxes called ComboFIPMake and ComboFIPModel and on the subform, which tests out OK when the sub form is opened on its own.
To get it to work as a sub form I need to reference throught the main form,
but just can't get it to work.

I use a query to filter the info for the second combo box ComboFIPModel.


I used this code in the criteria field of the query:

[Forms]![FIPInfoADD/EDIT]![ComboFIPMake]

I have been trying this line of code to reference the combo box on the Main/sub form setup:

Forms!NameOfParentForm!NameOfSubformCONTROL.Form!N ameOfControl

ie: [Forms]![EquipmentADD/EDIT]![ComboFIPMake].[FIPInfoADD/EDIT]![ComboFIPMake]

I get the "Enter Parameter Value" box.

Any Ideas?

Regards

Alastair
May 3 '10 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.