Autofill

[deadcalm]

Hi

I am pretty new to access, so bare with me.

I have created a small database for the help desk section of my job. When a staff member calls a help desk associate, the associate must type in the staff members SS#, last name, first name, work location, ect. ect. on the form.

Now, what I would like is that when the associate types in the SS# all the other details would automatically pop up in those fields. Currently, I am using one form from one table. I have another table with all the staff members information just sitting there, because I don't know how use it.

Any help would greatly appreciated!!!

 

[wizcow]

deadcalm

If you are just using your form to view one file at a time,
the DLookUp function might work.


In your 'LastName' text box in Control Source enter something like this;
=DLookUp("[LastName]","[NameOfTableWhereLastNameLives]","Form.[SS#]=[SS#]")

The DLookUp will look in the Table under the record that has the same SS# as entered on the form. Then DLookUp returns the LastName from that record.

Hope that helps!

Tom

 

[deadcalm]

Thanx, I will give it a try!