Find Record Command Button

[daherb]

I know you can create a find record command button really simply, which when clicked will display the find and replace window.

What i want to do is create a command button that will search a specific field that i specify in a report for the criteria i enter.

i.e i have a customer information form, which contains

AccountNo
CompanyName
Address
Postcode
Tel etc

what i want is a button that when clicked brings up an input field that allows the user to type the name of the company into this field, then when either the enter key is pressed or another button on this pop up window the matching record will be displayed or a error window stating that there are no matching records. Can anyone help me with this.

 

[daherb]

come on guys someone must know how to do this, please help

 

[Ron_dK]

I would never use a command button in a report.
I would use a form to show the customer info and make a combobox on the form, thru which fields /records can be selected. ( Also look at "Not in list" issue).

I would synchronize the report with the form and once people have selected the appropriate record in the form, it can be displayed in the report.
Hope that makes sense.