Find value in other form

L

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
 
J

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
Click to expand...

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 & " ' "
 
L

Lars Brownie

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

Lars

John W. Vinson said:
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
Click to expand...

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 & " ' "
Click to expand...
 
Top