Query Help

[FTW ODU]

So I'm new to Access and am having some basic troubles trying to get a simple query to work. I'm trying to setup a simple query where a person can type their last name and the form/query will output their employee ID. I've got it working the other way around but I cannot get what i want to work.
Currently i have two tables, one is tblEmployeeInfo with three columns; Emp_Number (Primary key), First_Name, Last_Name. The second is tblLogin with three columns; Employee ID, Last Name, Date. The two tables are related with a One (tblEmployeeinfo) to many (tblLogin) relationship.
IF anyone has any advice i'd greatly appreciate it!
Regards,


Josh

here is a screenshot on my tables. Like i said, i know i'm new to this so it's really basic

[June7]

Is Emp_Number an autonumber field?

Why is LastName in tblLogin?

Users should not work directly with tables and queries, only forms and reports.

Date is a reserved word - should not use reserved words as names. Also, no spaces or special characters/punctuation (underscore is exception) in naming convention. Title case is better than all upper case.

[FTW ODU]

No Emp_Number is fully populated with all ID numbers from our HR. What i'm trying to do is have a form built that a user can type their last name in and the employee number will autopoulate. employees here don't really know their ID numbers as HR uses a 12 digit ID (rather dumb imo). So i want to use employee ID as the Primary Key but assume the user's won't know them, thus, why i'm trying to make a look up query for the form. ultimately this will be for a login database to track user logins

[June7]

Use a form.

Set up a multi-column combobox. http://datapigtechnologies.com/flash...combobox3.html

I prefer VBA code to construct filter criteria. http://www.allenbrowne.com/ser-62.html

Dynamic parameterized query may be another option but I never use them. Emp_Number is a text type field? http://datapigtechnologies.com/flash...tomfilter.html

[FTW ODU]

Use a form.

Set up a multi-column combobox. http://datapigtechnologies.com/flash...combobox3.html

I prefer VBA code to construct filter criteria. http://www.allenbrowne.com/ser-62.html

Dynamic parameterized query may be another option but I never use them. Emp_Number is a text type field? http://datapigtechnologies.com/flash...tomfilter.html

Thank you!!!!!!!!!!! My form is now working as i wanted. I really appreciate the help!