I'm using recordset.findfirst to navigate to a certain record in a form.
I get the following error: RunTime error 3070 The Microsoft Access database engine does not recognize '[myfieldname]' as a valid field name or expression.
I double checked. That is exactly what the field is called, and it exists in the form.
What can be causing this error? Could it be because the form in question is a subform?