Find Button

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Find Button 1
Access Automatically Send a notification email once a record is added 0
Not clearing out a text box. 2
Enabling Properties 4
Linking Forms 2
Find button to locate record in form and display that record 11
Using the Find Command with a Command Button 2
Cmdbuttons to download 2

Back
Top