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