I have 6 combo boxes on a form, which call a report based on a query. The idea is that the user can query data 6 different way. How do I/ or the user know which one is actually running first. Would the order left to right make a difference? (None have sort ascending or descending)
multi combo boxes, which one runs
- Thread starter teiben
- Start date
KeithIT
Registered User.
- Local time
- Today, 14:44
- Joined
- Dec 20, 2004
- Messages
- 133
Left to right won't make a difference, it's all in the names and how you call the boxes. Do you have your query running the boxes in a specific order, or are these variables you collect in VBA and trasfer to a SQL statement?
If they are running in an access assisted query (i.e.: not VBA) then the sort order is dependent on the order in which you display your fields in the query. If you are in VBA, then you should be able to use code to allow the user to specify which fields they want to sort on first.
If they are running in an access assisted query (i.e.: not VBA) then the sort order is dependent on the order in which you display your fields in the query. If you are in VBA, then you should be able to use code to allow the user to specify which fields they want to sort on first.
Similar threads
