Good evening all,
I have a bit of code that I'm running into some trouble with.
Trying to have a combobox SELECT a record based upon a text string.
The table that I'm looking the value up in is named:
That Table has 2 fields Named (Data Type):
ShiftTypeID (autonumber) and ShiftType (text)
My Code is:
Dim strUseShiftType As String
strUseShiftType = "Clerk"
Me.cboShiftTypeSelected.RowSource = "SELECT ShiftTypeID, ShiftType FROM Shift_Types WHERE ShiftType = " & strUseShiftType
Me.cboShiftTypeSelected = Me.cboShiftTypeSelected.ItemData(0)
When I execute the code it opens an "Enter Parameter Value" "Clerk" input box. ??????