Shuoling Liu
Shuoling Liu

Reputation: 489

How to build the search form in ms-access

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

Upvotes: 1

Views: 3380

Answers (1)

Seth Spearman
Seth Spearman

Reputation: 6780

Shuolinq,

I answered a similar question yesterday here...

Populate list box from a table in vba

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

Upvotes: 1

Related Questions