Loop thru table Column

[bconner]

I have an access table that has one column named "Name". I have a login form that requires you to enter your name. I would like to take the value of the Name text box on the Login form and search for that name in the table if it exists I want login to procede and open a given form if login name doesn't match any of the names in the table I want a msgbox to popup and say "Incorrect Login Please Try again".

Can someone help me with the code? I am a beginner and I want to understand how to loop thru a table and test a value for true. Thanks

 

[vbaInet]

Use the Advanced Search feature on the forum and search for login forms under the Forms section. This topic has been covered in great detail and there's more ideas you could get from the discussions.

Also check out the Code Repository and Sample Databases sections of the forum too. I think there's a sample db somewhere showing how to handle this whole scenario.