Compare textbox value to record in table

[Mark]

Hi All,

Win XP, Office XP
What I am trying to do is create a login form. The problem is that I am
going to set the database up using Access security so that only admin users
can read the tables. I plan to have all info coming from stored queries with
"With OwnerAccess". With this in mind, what I am trying to do is: In the
afterupdate event of the username and password fields, look for the
existence (either true or false) of the username for the userid textbox and
the username & password for the password textbox.

My understanding of VB is very limited but from what I can make out, I need
to reference the result stored query/s.
Could anyone point me in the right direction please.

My table layout (Tbl_Users) is as follows:
Userid text PRIMARY KEY
Name text
Pwd text
Disabled yes/no
Security_level number
Ixxluda date/time

TIA

Mark