I am not sure if this should be in coding or forms...We are converting software where I work and I am trying to duplicate a way that a user does reports. Basically I want to create a form which allows her to choose her criteria that will be the control source for a query. Right now she has a field that she may only need one criteria or many, such as...Item_id like "RB* or Like "RC". it could be one like or up to 5 like.....How would I set up a form to do that....I know how to have the query look at what is the combo box value, but how do I have multiple or 1?
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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Combo Box that will add values to the query
- Thread starter MICKI0220
- Start date
You might consider using a multi-select list box to set the criteria. There are a number of resources on the web including FAQs here at Tek-Tips that describe how to do this.
Duane
Hook'D on Access
MS Access MVP
Duane
Hook'D on Access
MS Access MVP
- Status
Similar threads
