Autofill Fields

[Saifon]

Hi

Need some help with a table, or possible more to do with a form design..

I'm looking to autofill in a field depending on data that's in the previous field.

E.G. I have too fields.. One for employee and one for department.. I want the department field to automatically select the department whenever the employee is selected from the drop down list.

It's probably a simple query or something I need to do..

can anyone help..

Thanks
Saifon

 

[ColinEssex]

In your employee table, every employee should have a DeptID for the dept.

Use a Dlookup() to match the DeptID to the DeptID in the Dept table and display it on the form.

Col