How to build the search form in ms-access

Question

I have a ms-access database, now I need to build a search form on table "Samples" .

Now, the difficulties are I need 4 search criteria, SampleNo, SampleDate,SampleClient,SampleBatchNo.

The search criterias can work together or not.

I have a listbox to show the search results, and I want to be able to select more than one records in the results set and open a new form with the limitation of the selected records only.

Thanks

Answer 1

Shuolinq,

I answered a similar question yesterday here...

http://stackoverflow.com/questions/1123616/populate-list-box-from-a-table-in-vba/1125804#1125804

The only difference between that question and this one is that your rowsource will have multiple of those "Like" lines, one for each of your possible search terms and each pointing to a different control.

As for the second part of your question...opening a form using the selected results...that is a lot tougher. It can be done but only with VBA code.

Seth