multiple inputs in one unasigned box as criteria for a query

[vdzr]

example,

I made a form with one unasigned inputbox!

I want the User to fil in the different criteria items
Type item1 (enter)
Type item2 (enter)
.
.
.
leave blanc (enter)

the criteria for the query should be like

select* from table
where fielt1 = "'*" & item1 &"*' or '*" & item2 & "*'" ...

who can help me?

 

[Norris68]

See thread705-592872 you are using wildcards (*) you would want to use Field1 LIKE ... instead of =.

 

[vdzr]

I think there was also a tread that looks after a ";" character to split the variable input? But I can't find it ... sorry

e.g. input = item1;item2;itemn...

results in "like '*" & item1 & "*'" ...