FindFirst Help!

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!!!
 
K

Ken Snell

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combo box 0
Filtering form containing combo boxes 1
Problem with find first 11
Search combo boxes 0
FindFirst not working on second sub form 3
FindFirst error 3
Referring to text control in a form 3
synchronized combo boxes moving between records problem 3

Top