I am developing a database where I need to search through the data based on different critera. I am using combo boxes to do this, however I have run into a problem. Right now I have two combo boxes, and I want to be able to use each independently as well as a joint search.
I get in error due to...
I am developing a database where I need to search through the data based on different critera. I am using combo boxes to do this, however I have run into a problem. I can the first combo box to search correctly, however when successive combo boxes are added they wont search correctly. Right now...
I am using DLookup to search for a value called CaseID from a query, qrycombo1, but I get an expected = compile error.
DLookup("CaseID","[qrycombo1]", "RouteNumber = '" & Me!cboRoute.Value & "'")
Could anyone point me in the right direction?
Thanks
Craig
I have a form which currently has 2 combo boxes, and I use them to sort data from a query I created. My goal is to be able to use the boxes to search independent of one another and in conjunction with one other. I have attached my code. Any help would be greatly appreciated.
Option Compare...
If Ive got a combo box named, cboRoute, and it has certain values. How do I get the list box, lstCrashes, to display the query results from a query called, qryCombo1, when a value in the combo box gets selected?
Thanks!
The problem I have is that I currently have two combo boxes that produce results to a list box, however both need to be used inorder for the results to show. I need to add more boxes, but be able to get data without having to select every box.
Any help would be greatly appreciated.
Private...
The problem I have is that I currently have two combo boxes that produce results to a list box, however both need to be used inorder for the results to show. I need to add more boxes, but be able to get data without having to select every box.
Any help would be greatly appreciated.
Private...
I've created a form where I need to use combo boxes to sort the data from a query. I currently have two combo boxes that work and display the correct data, however both boxes have to be used in order to display the search. I want to be able to have the list box show the results after the first...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.