Subform with bound combo box problem

[Guest]

Hi All

I've created a subform with bound combo boxes. In combobox1 are choice for
performance ratings, distinguished, Competent, Adequate, etc. Based on that
selection combox2 has a list of percentages that can be selected. This form I
want to link to the main from which has emlployee information. The subform
works fine until I attach it to the main form. When I attempt to open the
main form a dialog box appears asking me to enter parameter value, Form!Bound
Combo Form!Rating.

I am not sure how to correct this problem. Your help is much needed and
appreciated. Thanks

Talib

 

[Guest]

If you refer to the ComboBox somewhere as

Forms![FormName]![ComboName]

Then when you open it from a sub form, the path to the combo changes

Forms![MainFormName]![SubFormControlName].Form![ComboName]

 

[Guest]

Thanks this makes perfer sense.
--
tm

If you refer to the ComboBox somewhere as

Forms![FormName]![ComboName]

Then when you open it from a sub form, the path to the combo changes

Forms![MainFormName]![SubFormControlName].Form![ComboName]



--
Good Luck
BS"D

Hi All

I've created a subform with bound combo boxes. In combobox1 are choice for
performance ratings, distinguished, Competent, Adequate, etc. Based on that
selection combox2 has a list of percentages that can be selected. This form I
want to link to the main from which has emlployee information. The subform
works fine until I attach it to the main form. When I attempt to open the
main form a dialog box appears asking me to enter parameter value, Form!Bound
Combo Form!Rating.

I am not sure how to correct this problem. Your help is much needed and
appreciated. Thanks

Talib