a simple password form

[neilb]

Hi

I have just started to use Access after using Excel for the last 2 years.

I am trying to write a simple password form. What I have done so far is created the form with 1 combo to enter the user ID and one text box to enter the password.

I am then trying to write a simple if then statement in VBA which checks the user ID and Password.

How do I use the inputted user ID and Password from the form in the VBA?

I have tried
DIM USERID as string
DIM Password as string

UserID="[userid]"
password="[password]"

I have put the form fields in [].

Can any one help ray:

cheers

 

[Russell Hauf]

Try something like:

UserID=Me.txtUserID
Password=Me.txtPassword

Where txtUserID is the name of the text box on your form...

HTH,

Russell

 

[neilb]

Cheers Thats it. I thought it was obvious