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

On the actual subform where it works, I'm syncing the fields with a query
and macro like in the example file "How to synchronize combo boxes.accdb".


"Douglas J. Steele" wrote:

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!N ameOfControlOnSubform

Note that depending on how you added the subform, NameOfSubformControl might
be different than the name of the form being used as a subform.

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

"Mac" wrote in message
...
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.


.