I am trying to tweek a Form load for a Clock out event. When the user selects ClockOut command it opens a Clock Out Form. That Form looks to a query of all "open" timecards for the logged in employee.
If there is only 1 timecard open for the Employee in the query I want it to actually select that timecard in the form's ClockIn time Combobox.
However, it updates the list for the combobox, but I'm doing something wrong in the selecting of that item.
Here is my code:
Me.cboClockInSelector.RowSource = "SELECT TimeCardID, ClockIn_Emp_ID, ClockTime_Shift_Begin, ClockEvent_Shift_In" & _
" FROM qry_TimeCards_ToClockOut" & _
" WHERE ClockIn_Emp_ID = cboSelectEmpID.Value;"
If Me.cboClockInSelector.ListCount = 1 Then
Me.cboClockInSelector = Me.cboClockInSelector.ItemData(0)