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
![]()
![]()