Using multiple criteria from a single form field

  • Thread starter Thread starter HM
  • Start date Start date
H

HM

Greetings All,

I have a form that the user can enter data into a few fields (text boxes)
(customer name, date, part number, etc) . The user then submits the
information and runs my query. I am wondering

Right now in my criteria field in my query I am using:

[forms]![frm_customer]![customer]

Is there a way that I can have the user enter multiple customer names
together in the form so that multiple customers show up in my report? Right
now I run it by going straight to the query field and use the "And"
function, but its not something I want my users doing.

Any help/suggestions would be greatly appreciated.


Hanie
 
The best method is to use a multi-select list box and some code. If you want
a klutzy no-code solution, you can use a column in your query with an
expression:
IsItIn:Instr(Forms!frm_Customer!Customer, [CustomerField])
and set the criteria
0
Click to expand...

--
Duane Hookom
MS Access MVP


HM said:
Greetings All,

I have a form that the user can enter data into a few fields (text boxes)
(customer name, date, part number, etc) . The user then submits the
information and runs my query. I am wondering

Right now in my criteria field in my query I am using:

[forms]![frm_customer]![customer]

Is there a way that I can have the user enter multiple customer names
together in the form so that multiple customers show up in my report? Right
now I run it by going straight to the query field and use the "And"
function, but its not something I want my users doing.

Any help/suggestions would be greatly appreciated.


Hanie
Click to expand...
 
Back
Top