FindFirst Help!

  • Thread starter Thread starter Courtney
  • Start date Start date
C

Courtney

Hi!
I'm trying to use FindFirst to find a record identified
by two criteria entered into a form. My code right now
reads such:

rst.FindFirst "[id number] = " & Me!Text1 & "And [reabs]
= " & Me!Combo17

ID number is entered into a blank text box as a number,
and reabs is selected from one of two options in a combo
box. But I keep getting an error when I try to use it
that says "Microsoft Jet database engine does not
recognize 'Abstraction' as a valid field name or
expression" ('Abstraction' and 'ReAbstraction' being my
two choices for my combo box). Is it a problem with my
grammer or with using a combo box in FindFirst? Thanks so
much for any advice you can give!!!
 
Most likely, this error is occurring because you're not putting a space
between the value from Text1 control and the And of the expression. Put a
space in front of And in the text string.

rst.FindFirst "[id number] = " & Me!Text1 & " And [reabs] = " & Me!Combo17
 
Back
Top