Record being change in reference table

[KLR]

I have a reference table that lists employees. I have set up a form
that logs all incoming orders and uses a dropdown for employee
handling that order, from the reference table. When a new record is
entered and employee selected from the dropdown, the very first
Employee name in the reference table changes to match that in the
record.

I have no idea why this is happening - can anyone help?

 

[John W. Vinson]

I have a reference table that lists employees. I have set up a form
that logs all incoming orders and uses a dropdown for employee
handling that order, from the reference table. When a new record is
entered and employee selected from the dropdown, the very first
Employee name in the reference table changes to match that in the
record.

I have no idea why this is happening - can anyone help?

Check the Control SOurce of the combo box. It should be the employee ID field
*in the Orders table* - it sounds like it's the employee ID in the Employee
table.

If this isn't the problem, please post the SQL view of the form's
Recordsource, the Control Source of the combo box, and the RowSource of the
combo.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com