Access 2010 Form w/Dependent Combo Box - How to Query on that field?

[BlueHorizon]

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

 

[dhookom]

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

 

[BlueHorizon]

Thank you - I'll give it a try!

Best,
Blue Horizon