Check textbox value against a table of stored values

[Carlos]

I have user ID's stored in a table. I would like to create a form with
a textbox that allows users to enter their ID's. Once they enter their
ID into a textbox, I would like to program a command button to take the
value of the textbox, check to see if the ID is in the table. If it
is, then I would like a value of true to be returned; otherwise, false.
Can someone offer some advice on that type of code?

 

[Michel Walsh]

Hi,


DCount("*", "TableNameHere", "ID=" & id )


would return 0 is the numerical value id is not under ID for the mentioned
table.




Hoping it may help,
Vanderghast, Access MVP