Check textbox value against a table of stored values

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Carlos - 22 Nov 2005 19:42 GMT

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?

Reply to this Message

Michel Walsh - 06 Dec 2005 12:13 GMT

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

>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?

Reply to this Message