Solved single textbox search

[FahadTiger]

Hi Experts

I want search more than one record from single textbox and when I text (1,3) give me a records of 1 and 3 ..I used this code

.Filter = "([EmpID] In(" & [Forms]![Form 1]![TxtID] & "))"

.FilterOn = True

But it give me un Error

Any advise plz

 

[FahadTiger]

Sorry for every one
its working with me in vba.. but i want it in query builder

 

[Gasman]

You could try ?

SELECT TestTransactions.*
FROM TestTransactions
WHERE (((InStr(1,[Forms]![Form4]![txtCopy],[TestTransactions].[ID]))>0));

 

[FahadTiger]

You could try ?

SELECT TestTransactions.*
FROM TestTransactions
WHERE (((InStr(1,[Forms]![Form4]![txtCopy],[TestTransactions].[ID]))>0));

thank you Sir Gasman.. its perfect