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!NameOfPar entForm!NameOfS ubformCONTROL.F orm!NameOfContr ol
ie: [Forms]![EquipmentADD/EDIT]![ComboFIPMake].[FIPInfoADD/EDIT]![ComboFIPMake]
I get the "Enter Parameter Value" box.
Any Ideas?
Regards
Alastair
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!NameOfPar entForm!NameOfS ubformCONTROL.F orm!NameOfContr ol
ie: [Forms]![EquipmentADD/EDIT]![ComboFIPMake].[FIPInfoADD/EDIT]![ComboFIPMake]
I get the "Enter Parameter Value" box.
Any Ideas?
Regards
Alastair