Hi there,
I am a novice at Access programming but I am flustered by this error and
don't understand what I am doing wrong, any help is appreciated.
Here is my code:
Sub SetFilter()

   Dim LSQL  As String
 
   LSQL = "select * from dbo_DDXLMO"
   LSQL = LSQL & " where St_Offshore = '" & cboSelected & "'"

   Form_frm_OffsetWells_sub.RecordSource = LSQL

End Sub

I am calling the SetFilter routine from my Form_Open Procedure and all I have
is a form and subform and in the form I have an unbound combo box that
selects St_Offshore from table dbo_DDXLMO.
I am just trying to populate the subform with results from my combo box and I
keep getting this error and I have tried a million things and nothing is
working.
Please help, thanks!