Combo value based on Query

[Csalge]

Hi.



I have two combo boxes. Combo A and Combo B. Combo B pulls a query that picks case#s randomly based on selection on combo A. I was able to get the query to work and to display the value in combo B. However, the value stored in my table is the random ID #. I tried changing the properties in the table to a combo and setting the widths to 0" and 2" but it still only shows the ID#. Any suggestions?

[June7]

Show properties of ComboB:

RowSource
ControlSource
BoundColumn
ColumnCount
ColumnWidths

[Csalge]

ROW SOURCE:
SELECT TOP 1 tblProduction.[fk_productivity pointID], tblProduction.[Case Number], Rnd(tblemployee.[employeeID]) AS expr1, tblEmployee.EmployeeID
FROM ([Employees Extended] INNER JOIN tblEmployee ON [Employees Extended].EmployeeID = tblEmployee.EmployeeID) INNER JOIN tblProduction ON tblEmployee.EmployeeID = tblProduction.fk_EmployeeID
WHERE (((tblProduction.[fk_productivity pointID])=[Forms]![Performance Appraisal]![randomcombo1]) AND ((tblEmployee.EmployeeID)=[TempVars]![CurrentUserID]) AND ((tblProduction.DateofProductivity) Between [Forms]![Performance Appraisal]![StartDate] And [Forms]![Performance Appraisal]![EndDate]) AND ((tblProduction.Validation)=True))
ORDER BY Rnd(tblemployee.[employeeID]) DESC;

CONTROL SOURCE: element1case3

BOUND COLUMN: 1

COLUMN COUNT: 2
COLUMN WIDTHS: 0"; 2"

[June7]

Darn, you have a TempVars variable in that query? Never used them.

Far as I can tell ComboB should be saving the pointID value.

Since you aren't showing the two employeeID fields in the combobox list because of the ColumnCount, no reason for them to be in the fields of the query, just uncheck the box below field in the query grid. The fields will still work in the WHERE and ORDER BY clauses.