Trying to build a form that displays information from table

[ZeroWard]

In short, I'm trying to build a dormitory resident table with a form that would allow people to search for residents, however due to security concerns, we would like to force those searching to input a first and last name before it would kick out any more information.

I'm assuming it would involve some sort of recordset VBA command, such as one used for a login form, I just don't have enough VBA experience to know exactly how to code it.

Any help would be greatly appreciated.

Thank you!

[RuralGuy]

Have you looked at the sample templates that come with Access or those on line? I'll bet you can find something close that you can modify to suit your needs.