Opening All records from a search form

[jobrien4]

I have a search form that allows users in input up to 5 fields to search for previous quotes:

Customer Number
Part Number
Revision Number
Quote Number
Request For Quote Number

The results are displayed in a List Box. If the user double clicks one the results, the record opens up by passing filtering the next form to equal the selection's Quote Number (which is the primary key).

I would like a way to have an Open All button to open up all search results in the form.

I was able to do this on a separate search form in the database, but that search already narrowed the results to only one part number. Because of that, I could filter the opening form as to all records with that part number.

The only way I can think to do it is create an If Then that identifies exactly which combination of the 5 fields the user searched for, and has a unique filter based on which combination was used in the search. However, this would require a 120 different OpenForm statements. Is there an easier way to do this?

 

[jobrien4]

I just had the following idea:

Dim strOpenFilter as String

If IsNull(CustomerNumber) = False Then
OpenFilter = OpenFilter + " [CustomerNumber] = 'CustomerNumber'"
End If

etc

Then OpenForm(frm_Results,,,strOpenFilter)

Would this work or should I not waste my time?

 

[jdraw]

There is a free video tutorial here that may help.
http://www.datapigtechnologies.com/flashfiles/buildcustomfilter.html

There are several tutorials.