Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
More on FAQ Combo Box Limit
Thanks again for your help! Your code is not working for an enhancement I want to make, the part that does not work is: Else sql = "SELECT YourTable.YourField FROM YourTable;" I want my Combobox2 to have a "*" selection just like ComboBox1. So, I replaced the code above...- dchMPower
- Post #5
- Forum: Microsoft: Access Forms
-
More on FAQ Combo Box Limit
Beautiful, thank you very much! One more question if you don't mind. Here is the rowsource in ComboBox1: SELECT MyTable.Field1, MyTable.Field2 FROM MyTable UNION SELECT "*" As Field1, "*" as Field2 FROM tDistAllocations ORDER BY Field2; What can I add to this combo box...- dchMPower
- Post #3
- Forum: Microsoft: Access Forms
-
More on FAQ Combo Box Limit
Hello, I have a question which expands on the FAQ posted below: >How do I limit the contents of one combo box based on the >selection in another? >faq702-681 I am using two combo boxes as search criteria for a query. The second Combo Box limits the list based on the value of the first combo...- dchMPower
- Thread
- Replies: 5
- Forum: Microsoft: Access Forms
-
Creating a "Select All" option in a Combo box that filters a report
Hello, Need a little further help with the combo box that is based on 2 columns. The code you posted is: SELECT ProjID, ProjName FROM tblProjects UNION SELECT "*" As Projid, "<All>" As ProjName FROM tblProjects ORDER BY ProjName Question: If I have multiple ProjName for...- dchMPower
- Post #11
- Forum: Microsoft: Access Forms
