Link to home
Start Free TrialLog in
Avatar of the_Apple
the_Apple

asked on

In in Parameter

is there a way that I can put in a form field that can contain data with

 in ("","")

For example, The user will input in this filed data such as red, green, black..etc and the data some how will be placed in the below and we can use up to 5 or six:

In ("red","Green","black")
Avatar of IrogSinta
IrogSinta
Flag of United States of America image

This is really not clear.  Can you provide more details?
Avatar of the_Apple
the_Apple

ASKER

I have a bif set of data and I would like to filter by input code. so I want the query result to give me coustmers who is

in ( red, green, black).

so the result will show only customer that has the 3 color above. I wish I can use query Parameter so the user can have a pop up and they can enter crieria that they need the query to return.
It depends on your data. Can you show your table with some sample data?
"so the result will show only customer that has the 3 color above"

Do you mean Any of the 3 or All of the 3.
all the 3 colors but it may show any cusatomer that has more than this particular 3 colors
SOLUTION
Avatar of mbizup
mbizup
Flag of Kazakhstan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
would it apply in  subform

if the subfom is called ADD_Subform
Textbox is Filter_txt
rowsource for the filed is:
Color_Name

Thanks
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial