Hi all!
Through tutorials on the web, I found how to add a dependent combo box to a field on my frmMASTER form built from my tblMASTER.  The field on frmMASTER [strCHC] points to a different table [tblDependentCombo] for the dependent choices which will be shown in [strCHC_SubType].

Here's my question:  Having done this on my form, how do I query on that field?  It doesn't appear on my table.  Should it somehow be connected to my tblMASTER.  I don't see a choice to create a query from a form.

Any help is appreciated.  I don't know SQL or VBA but I did figure out enough to understand the tutorial.  So please be patient.  Thanks in advance.

 

Best,
Blue Horizon
 

Apparently the combo box isn't bound to a field. If you wan't include this value in a query, you must add the table containing the value in the query.

Duane
Hook'D on Access
MS Access MVP

Thank you - I'll give it a try!

Best,
Blue Horizon