filter and combobox

[NetworkTrade]

Access03 Form is sourced from query; only using query to alphabetise
order by name field...otherwise could be on table itself.

One open button has form open argument to a selected geo area i.e. state

Another open button has form open argument to a selected interest i.e. fishing

works fine

either way opened there can be alot of records so that the user does not
want to serially click thru the names alphabetically to the one they want -
they want to jump to the name they seek...

entering a single combobox onto the form (wizarded to select record) shows
all names and doesn't get filtered as is the form itself...so many of the
names can't be selected....

do I manipulate the comboboxes underlying query? how would one toggle from
the state column to the interest column as having criteria or not.....??
would welcome advice.

 

[jversiz via AccessMonster.com]

Are you trying to limit the number of records shown in your combo box
depending on answers from another? It sounds like it. Do some research on
"dependent combo boxes". Basically you will you a combo box, but you will
add the "WHERE" function to the rowsource.

Regards,
James C.

 

[AccessVandal via AccessMonster.com]

Yes, cascading combobox maybe the answer. However, if the data in each
comboboxes are independent, you don't need the cascade combos.

Why opened two forms, where you can open just one form? Use the form's
recordsource like....
Select field1,field2.....From Table1 Where field1 = Forms!YourMainForm!
YourComboBox1 And
field2 = Forms!YourMainForm!YourComboBox2;