Access Form Autofill Option

[smarty84handsome]

I am new to MS Access and so far i have managed to create two table i.e. Employee file & Discrepancy Table. I have created form with name Discrepancy Form.

Employee File Table Contents

1) Emp Id
2) First Name
3) Last Name

Discrepancy Table Contents

1) Emp Id
2) First Name
3) Last Name
4) Date
5) Amount
6) Explaination
7) Type with 2 fileds set (Cashier error & Customer service error)
8) Status with 2 fields set (New & Reviewed)
9) Auditor comments

Finally i have created a form using Discrepancy Table Contents now as mentioned i have emp id in the first box and then followed by rest of the contents. I am willing to insert autofill option in such a way that once i select emp id it should automatically populate first name & last name of the corresponding employee. I am stuck with this problem and i so new to VB & SQL both. I looked various tutorials tried all different options but looks like and i am not writing the correct string in VB editor. I would appreciate if someone could show me both the ways of creating autofill option by coding as well as non-coding both.

[pbaldy]

See if this helps, including the recommendation to not store the name fields in the second table:

http://www.baldyweb.com/Autofill.htm

[smarty84handsome]

See if this helps, including the recommendation to not store the name fields in the second table:

http://www.baldyweb.com/Autofill.htm

Sir i want to make sure if i am understanding u correctly. Based on your reply i need to create table as below pls correct me if i am wrong !!!

Employee Table

1) Employee Number --->Primary Key
2) First Name
3) Last Name

Discrepancy Table

1) Employee Number
2) Over/Short
3) Status
4) Explaination
5) Auditor Comments

Then create form importing Discrepancy Table. My question is how would it display first name & last name in form ?

[smarty84handsome]

or should i use both table when i create a form so that it imports informatin from both table ?

[pbaldy]

Properly normalized design would not store the names in the second table, just the ID. You'd display the names on the form as discussed in the link. In reports and such you would use queries that joined the two tables together.

[smarty84handsome]

I have attached the DB file for you to help me in the form section i tried doing as mentioned in the link but somehow it's not working pls help.

[smarty84handsome]

Sir tht link u provided is worth a million I created a combo box and it worked in form. Now I want to autofill first name & last name when I select employee number how wud I do this ?

[pbaldy]

Have you tried the method detailed in the link? There was no sample attached to the previous post.

[smarty84handsome]

Bingoooooooooo problem solved thanks for the help.

[pbaldy]

No problem, and welcome to the site.