Form Help Needed

  • Thread starter Thread starter MCJ
  • Start date Start date
M

MCJ

I am putting together a Call Log database in Access 2000. So far here
is the setup: I have a table (Employees)in another database linked to
the Call Log database. The employee database contains Employee name,
username, phone extension, department, and email address.

The Call Log form has the same fields that are in the employee
database. When I log a call I select the employee name from a drop
down list (combo box), and I manually fill in the rest of the data
(ext, dept). What I would like to do is have the other fields
automatically fill in once I select a user name. So when I select Jane
Doe from the drop down list, I want her phone extension, username,
dept, and email address to automatically fill in.

I really have no idea how to accomplish this. Any help would be
appreciated.

Thanks
 
Try this: create an update query that updates the Call Log
table from the info in the Employee table where the
username = the value of the Combo box (pull down). Then,
have that query run in the AfterUpdate of the Combo box.
(to be more elegant, you might set warnings off before
running the query and on again after running the query.)
Hope this helps.
 
Back
Top