asked on

Find a record with an Input box

experts,

I am using the below but get a syntax. Any suggestions?
Private Sub cmdFind_Click()

Me.Recordset.FindFirst "End User" & InputBox("Enter Name")

End Sub

ASKER CERTIFIED SOLUTION

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

pdvsa

ASKER

OK that works. Can you add a "like" into that? I wonder how this code addresses the fact that there could be two or more records if i use a "like"? I assume it would go to the first one but then not sure about the second one. Do you have an idea about that or maybe I should go about it another way.

thank you

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

" I assume it would go to the first one but then not sure about the second one."
As is, it's just going to find the first occurrence in the Recordset.

Well, using Like is a different paradigm. You will have to decide what to do - if anything - with additional occurrences ... or something that is only a partial hit ... ala Like "ABC" ....

mx

pdvsa

ASKER

OK. Well I think I need to rephrase this question. I will close it out as you have provided an answer. I will ask another that requests to handle multiple occurences and see what happens. I do need to handle multiple occurrences for "like".

thank you mx

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

You are welcome.

Yes ... decide "*how* ... you want to handle multiple occurrences first ....

mx