Find Button

M

Marat Mamedov

Hello

I was wondering if there was any way of making the find button in an access form search in more than one field. I have two particular fields in a form that I would like to have a combined search feature for. Is there any kind of code that might be need to manipulate the find button.

Any help would be greatly appreciated

Thank you

Marat Mamedov
 
P

Pavel Romashkin

Try something like

Me.Form.RecordsetClone.FindFirst "FieldOne = " & SearchCriteria
if Me.EOF then
Me.Form.RecordsetClone.FindFirst "FieldTwo = " & SearchCriteria
end if

Then, use Me.Form.RecordsetClone.Bookmark to position Me.Form.Recordset
at the located record.

Pavel
 

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

Crating User Form to Add Names 1
How do I set focus (and select text) on a text box on a modeless userform? 0
Find Button 1
How do I clear a form? 0
Linking text to photos 0
ASK Field Formatting 1
List all tables, including document structure 0
Finding the right style field in VBA 0

Top