 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / April 2008filter and combobox
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.  SignatureNTC 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. >Access03 Form is sourced from query; only using query to alphabetise >order by name field...otherwise could be on table itself. [quoted text clipped - 16 lines] >the state column to the interest column as having criteria or not.....?? >would welcome advice. SignatureBest Regards, James C. EDI Analyst 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; >Access03 Form is sourced from query; only using query to alphabetise >order by name field...otherwise could be on table itself. [quoted text clipped - 16 lines] >the state column to the interest column as having criteria or not.....?? >would welcome advice. SignaturePlease Rate the posting if helps you |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.