Use Variable @ Diff Form

[Bluie]

I have a login(Username & Password), and the username is not stored anywhere. is it to check from another table to see if the username and password is the same or not.

so how do i get this username if the id and pwd is matched and put them into another form?

 

[Mile-O]

The simplest method is to have a login form with the username and password. The user enters their details and clicks a button to which they are then logged in. Rather than close this form you can set its Visible property to No and, when you want to refer to it you can.

i.e.

If strPassword = Forms("frmLogin").txtPassword Then

 

[Bluie]

may i ask, where do i put that code at?

 

[Bluie]

i have been looking at this :

http://www.blueclaw-db.com/access_pass_parameter_global_variable.htm

but i dont know how to implement it into my db. can someone pls advise?