Create a "Find Record" button on a form

[OPathMan]

I am trying to create a button on a form that will open another form, then display a dialogue box in which I can type information (customer name)and then have that record appear in the form. The difficlty I'm having is to have the search/find feature to find "any part of field" (e.g. if 2 customer fields are: 1) DOE, John, and 2) DOE, Jane, I would want to type:"DOE", then record 1 would be found, then I would be prompted to "find next". I am currently trying to use 3 macros (OpenForm, GoToControl, and FindRecord). OpenForm and GoToControl are straightforward and work well. The FindRecord is the difficulty I believe. Any help with "Find What" syntax would be appreciated.

Dave

 

[PaulBricker]

You can try using the RecordsetClone.FindFirst method. I use it like this in the AfterUpdate event for a combobox, cboFindWO

Me.RecordsetClone.FindFirst "[WO Number] = " & Me![cboFindWO] & ""
Me.Bookmark = Me.RecordsetClone.Bookmark

Maybe that will spark some ideas.

Paul