Compare dataset to a form combo box

[PatCLC]

I have the following query in a dataset that I would like to compare to a combo box value and not have the static text, LD SPOILER PACKAGING.

Any help would be greatly appreciated



SELECT PR_EMP.EMPNO, PR_EMP.MIDDLE_NAME, PR_EMP.FIRST_NAME, PR_EMP.LAST_NAME, TA_LABOR.TIME_IN, TA_LABOR.SOURCE, TA_LABOR.SOURCE_ID, TA_LABOR.TIME_OUT, WORK_CENTER.EQNO,
WORK_CENTER.CNTR_DESC
FROM TA_LABOR TA_LABOR, PR_EMP PR_EMP, WORK_CENTER WORK_CENTER
WHERE TA_LABOR.PR_EMP_ID = PR_EMP.ID AND TA_LABOR.WORK_CENTER_ID = WORK_CENTER.ID AND (TA_LABOR.TIME_IN IS NOT NULL) AND (TA_LABOR.TIME_OUT IS NULL) AND
(WORK_CENTER.CNTR_DESC = 'LD SPOILER PACKAGING')
ORDER BY PR_EMP.FIRST_NAME

Continue reading...