I am stuck with syntax on a query for a recordset. The code is:
Set dbs = CurrentDb
Set rst = dbs.OpenRecordset("tblContracts", dbOpenDynaset)
'Filter the recordset
rst.Filter = "[Status] = ' & vblStatus & '[LegalOwner] = ' & vblUser & '[MMIDivision] = ' & vblDivision & '"
Set rstFiltered = rst.OpenRecordset
The rst.Filter gives a syntax error. Is there a place that explains the syntax for a query like this?