When name is entered in the Name field of the form I want the location to populate

[marksnwv]

I have a form called TaskCountSummary used by employess to log the work they complete each day. On this form they enter or choose their name from a combo box which contains their name and ID. The name and ID are validated by a table call Staff List. The information from the form is saved to a table called AllReportData2012. Once they enter their name I would like the location box to automatically poulate with the employees location. The employees location is part of each record on the Staff list table. I could use some help on how this should be accomplished. Thanks

[mejia.j88]

are all employee names in the combo box?

[mejia.j88]

Check out post 13, i think this is what you are looking for:

https://www.accessforums.net/showthr...762#post114762

[pbaldy]

Is this what you're after?

BaldyWeb - Autofill

[ssanfu]

The record source for the combo box should include the location field. In the after update event, push the location from the combo box into control. See http://access.mvps.org/access/forms/frm0009.htm

BTW, having the first name and the last name in the same field is a violation of the normalization rules. The normalization police won't come for you, but it is easier to combine the first and last names than to split them. Also, "Name" is a reserved word and shouldn't be used as an object name. See http://allenbrowne.com/AppIssueBadWord.html