Find Button question

[cbearden]

Does anyone know of where I can find something on how to create a Find button? I don't want to use the one you can create through the command button wizard b/c its not what I want. I need it to do a search by one control. If I use the wizard Find button it will be a pain for the user, with them having to click in the right control before searching.

Thanks a bunch!

 

[fred05]

this is the problem I had just this morning !

You need to do a combobox WITH the wizard, on your form, and then it asks you which field you will need to search !

 

[cbearden]

What I was looking for is a prompt. Like I have with my query. I have it where it asks you for the account number. It works and everything BUT it brings it up in a seperate window and in a datasheet view. I have been trying to get it where the query will pull up the record in the form...just like the find button(thru the wizard) does when a user clicks a certain control and searches by the criteria.