--------------------------------------------------------------------------------

Here are example of my tables:

one-to-many tblNames-tblAssets
one-to-one tblName-tbl General

tblNames
ID
Name

tblAssets
ID
Quarter
Year
Assets

tblGeneral
ID
Address
Phone


I have multiple data for names on assets, for example, ID "1" has assets for Q1 2012, Q2 2012...Q4 2013, etc. I would like 3 comboboxes (name, year, and quater) to filter/query text boxes on subforms.

I would also like the tblGeneral data (on the same subform if possible) to filter/query on Name only.

I am having trouble putting this together, please point me in the right direction. I know i need to add event for updates on the comboboxes. I can cascade the Q and Year combo boxes on Name cbo...