Search Form and Report Question

[Trojnfn]

I have a search form where I select search values from a pulldown and then click the search/command button. It lists all the summary data on single lines with a command button next to each. I then click on that button and it opens a report with all the detail information for that line.

Two questions :

1. Everytime I open the search form, all the values are already listed. When I select and search for a particular value, those come up and override what is already displayed on the screen. How can the values not be displayed as soon as the form is opened ? It should be a blank form and only display when I click the search/command button. How do I display a message if no records are found based on the selection ?



2. When I find and display the summary data that corresponds to the search criteria, I click on the button to open the report to show the detail. However, instead of only showing the information for that one record, it shows all the information for the search. For example, if I select Apples as my search, it will return 5 records. I select the first record only but the report shows the detail for all 5 records, one after another. How do I get it to only display the record that I selected, not all ?

[June7]

A label on form could be set as not visible then if a certain field of the form is null after the search effort, code could make the label visible. The label could be big red text that states NO RECORDS FOUND.

Is there only one criteria involved in this filtering?

Review these tutorials that demonstrate use of query parameters to filter data:

http://datapigtechnologies.com/flash...tomfilter.html

http://datapigtechnologies.com/flash...mtoreport.html

The technique is easy and can handle multiple criteria. However, I don't really like query parameters. An alternative to filter report data is WHERE CONDITION argument.

DoCmd.OpenReport "report name", , , "fieldname=" & Me.combobox