Search command in form

[mhuth3]

Hello,

I would like to create a search command button in a form that will search my db without going through the Find Next dialog box. EX: I enter a customers telephone number in my form, press the search button and it searches the db and returns a match along with all the customer record information.

 

[John Big Booty]

Perhaps the sample here will give you some inspiration.

 

[mhuth3]

John, Thanks for the quick response. Your code worked great!
It's not quite what I'm looking for. EX: I want to create a form on which I can enter a phone number, then select a command button, I'll call SEARCH, and the comand will search my db without additional dialogue box(s), and return all the data for that record and propagate the form fields I've selected.

 

[bob fitz]

Perhaps I'm missing something here, but if you only ever want to search with the telephone number why not just use a combo box in the header section of a form that is bound to the records that you want to search? You can even use the wizard to create the required combo box and code.