Find value in other form

[Lars Brownie]

From FormB I'm trying to use FindFirst to find a record in FormA:

Forms![FormA].Recordset.FindFirst "ID_car = " & fldQuickSearch

I get a 'missing operator' error. Can someone explain what I'm doing wrong?

Thanks, Lars

 

[John W. Vinson]

From FormB I'm trying to use FindFirst to find a record in FormA:

Forms![FormA].Recordset.FindFirst "ID_car = " & fldQuickSearch

I get a 'missing operator' error. Can someone explain what I'm doing wrong?

Thanks, Lars

Step through the code and see what the value of fldQuickSearch is at this
point. You'll get that error if it's a NULL Variant.

If ID_Car is a Text field you need some quote delimiters - I wouldn't expect
that to give this particular error but if it's the case try

"ID_Car = '" & fldQuickSearch & "'"


Spaced out for readability that's

"ID_Car = ' " & fldQuickSearch & " ' "

 

[Lars Brownie]

Thanks John!
Indeed I used the wrong field: fldQuickSearch. Got it working now.

Lars

From FormB I'm trying to use FindFirst to find a record in FormA:

Forms![FormA].Recordset.FindFirst "ID_car = " & fldQuickSearch

I get a 'missing operator' error. Can someone explain what I'm doing
wrong?

Thanks, Lars

Step through the code and see what the value of fldQuickSearch is at this
point. You'll get that error if it's a NULL Variant.

If ID_Car is a Text field you need some quote delimiters - I wouldn't
expect
that to give this particular error but if it's the case try

"ID_Car = '" & fldQuickSearch & "'"


Spaced out for readability that's

"ID_Car = ' " & fldQuickSearch & " ' "