search for mulit value ...

[warzer]

Hello all
I want to build a query to find some values by using textboxes form how to do that?

example :

ID name
1 AAA
2 BBB
3 CCC
4 DDD
5 EEE

when insert ID 1,3 and 4 in text0 on form1

the query find name for ID 1,3 and 4 but using [Forms]![Form1]![text0] ,( criteria in ([Forms]![Form1]![text0]) ) ,,

Result

name
AAA
CCC
DDD

Regards ...

 

[Uncle Gizmo]

I recall a post I participated in a few days ago where are user asked a very similar question. I have linked the questions together as you may benefit from the answers the other user received. The thread is Here:- https://www.access-programmers.co.uk/forums/showthread.php?t=293201