Hi,
I've a unbound combox field in main form, which upon select the subform should display the information. I tried this code but it gives me an error :
Dim strSQLSF As String
strSQLSF = " SELECT * FROM UT_table_EOM_UT "
strSQLSF = strSQLSF & " WHERE UT_Table_EOM_UT.Expr7 = '" & UTEOM_SEL & "'"
Me.UT_Table_EOM_UT_subform.Form.RecordSource = strSQLSF
Me.Requery
Run-time error 2001
You canceled the previous operations
I've a unbound combox field in main form, which upon select the subform should display the information. I tried this code but it gives me an error :
Dim strSQLSF As String
strSQLSF = " SELECT * FROM UT_table_EOM_UT "
strSQLSF = strSQLSF & " WHERE UT_Table_EOM_UT.Expr7 = '" & UTEOM_SEL & "'"
Me.UT_Table_EOM_UT_subform.Form.RecordSource = strSQLSF
Me.Requery
Run-time error 2001
You canceled the previous operations