Find Record Button

[data808]

I like how the button works except for one thing. I am not able to change the "Look In:" drop down menu to another field. I can only search the field my cursor is in. Is there a way to make it so either I can list the fields in the drop down menu to my liking or at least have all fields list in the drop down menu for "Look In:"? Its a bit annoying to have to make sure I remember to click the field I want to search in before clicking the Find Record button.

Any help is appreciated. Thanks.

[June7]

No, cannot change behavior of the intrinsic Find dialog.

[data808]

would i be able to make a custom button in that case? do you know how to create the code for it?

[June7]

The combobox RowSourceType would be Field List and the RowSource would be table or query. Have a textbox for entry of criteria.

Code something like:

Me.Filter = Me.combobox & " Like '*" & Me.textbox & "*'"
Me.FilterOn = True

That assumes all fields are text type.

For more ideas, review http://allenbrowne.com/ser-62code.html