I have a form with a combobox using the following query:
Code:
SELECT   JobNumber,
         CustomerName,
         [PO],
         [Customer Motor #],
         assm_status
FROM     tblJob
WHERE    assm_status<>"Done"
ORDER BY CustomerName;
The bound column is column 1
Code:
Private Sub CustomerSearch_AfterUpdate()
On Error GoTo Err_customersearch_Click
    Dim stDocName As
...