Coding Login Menu

[sharVyn]

I am new to VBA. I want make a login menu for a course work. I am having some difficulty.


- I have a frmLoginMenu and tblLoginMenu
-In tblLoginMenu I have a record named "firstrun". its values must be 0 or 1
My objective: I want the system to check if the value is 0 or 1.
But i don't really understand how to pull up (check) the value from record "firstrun" from tblLoginMenu
Now I am coding frmLoginMenu. I want to know what code to use for the system to check if the value is 1 or 0.
If anyone can explain this much to me, i think i'll be able to continue the remaining parts.

But, please use simple codes as I am already confused

[pbaldy]

One way would be a DLookup! If you just wanted to look it up. If you wanted to manipulate the value after looking it up, a recordset.

[sharVyn]

uhhhm, i wanted to use the command "[tblLoginMenu]![Username]", but i do not know how to use it properly. I want to pull the value from the record "firstrun".
if i am not mistaken, Dlookup is available only when designing the interface and adding different buttons. it is not available when using VBA

[pbaldy]

You are mistaken, DLookup is available pretty much anywhere. You can't refer to the table that way. Your two basic options in VBA are DLookup and a recordset.