Combo Box Issues on Form

[aceoftrades]

Let me start off by saying I am new to Access...I have a data entry form that the user is going to enter a project for a customer. There will potentially be numerous projects. For each project the user needs to be able to enter a Sales Rep for each project. I have a table tblSalesRep listing all reps and those names show up in the combo box. The problem is when I change the Sales Rep for a new project it changes it for all projects. Thanks in advance.

[June7]

You have a field in projects table for the sales rep? Combobox needs to be bound to that field.

[aceoftrades]

Ok let me complicate things...forget the tblSalesRep...I changed things to tblEmployees with a combo box witch has a Sales, Field, Office selection. I have a query for each a qrySales qryField qryOffice. Each project will have 2 employees assigned to it (Sales, Field). I want the First and Last Name displayed for both Sales and Field on the form but the Employee_ID recorded in the tblProject. Hope I explained this correctly. Thanks.

[June7]

The combobox can be multi-column. http://www.datapigtechnologies.com/f...combobox3.html

RowSource like:

SELECT Employee_ID, LastName & ", " & FirstName As EmpName FROM tblEmployees;

ColumnCount: 2
BoundColumn: 1
ColumnWidths: 0";2.0"

[aceoftrades]

The combobox can be multi-column. http://www.datapigtechnologies.com/f...combobox3.html

RowSource like:

SELECT Employee_ID, LastName & ", " & FirstName As EmpName FROM tblEmployees;

ColumnCount: 2
BoundColumn: 1
ColumnWidths: 0";2.0"

Worked perfect...Thank you