Combox Box with Subform (1 Viewer)

[momoko]

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

 

[MStef]

Check your code, if the all names (fields, tables) are correct.

 

[momoko]

Yes I've ensure all fields and table is correct. This is working on other form but for this it is giving error which puzzle me.

 

[MStef]

Try "!" instead of "."

 

[momoko]

Tried ! but gives me error that MS can't find the field. Are there any other method that I can use?

 

[neileg]

Why don't you use a querydef instead of building the SQL in code?