Synchronized combo boxes in subforms

  • Thread starter Thread starter Mac
  • Start date Start date
M

Mac

I can sync combo boxes in a form, but cannot get it to work on a subform. I
do not know VBA, so if you try to give me code, that won't help. I use
macros and queries for everything, I haven't learned VBA yet.
 
How are you syncing them on the form?

If the RowSource for the second combo box points to the first combo box to
limit it, recognize that you cannot refer directly to controls on forms
being used as subforms, you have to go via the parent form.

Forms!NameOfParentForm!NameOfSubformControl.Form!NameOfControlOnSubform

Note that depending on how you added the subform, NameOfSubformControl might
be different than the name of the form being used as a subform.
 
The combo box works on the subform if you open the subform by itself... but
when embedded in the tabbed form it fails. Here is how it's set up.

Form: card_info_form
Tabbed form: TabCtl_card_info
Tab: Exceptions
Subform: exception_requests subform
Independent field: exception_type
Dependent field to exception_type: exception_category
 
seriously? I stumped you, or did you give up on me? I still cannot get
this to work, please advise.
 
Sorry, I'm not familiar with the example file to which you're referring.
You'll have to provide the details of what you're doing.
 
Back
Top