Retrieving Records based on a Multiple Selection Form

J

Jasmine

Is there a Form Wizard that's availabe that can search information based on
what's entered on a form ?
I hate to write code for something that's already available

Example:

I want to have a Form with the following field

1. Client First Name
2. Client Last Name
3. Policy Number
4. State Licensed
5. Carrier
6. Status
7. SSN
8. App Number
9. App Entry Date
10. Case Manager


I want this form to retrieve Client Information based on a single item or a
multiple select items.
When the record is found I want to display a close match of all clients
found in a datasheet view , so when
I select a specific client I would trigger a form with the selected client
information.
 
A

Albert D. Kallal

Yes, this feature is built into ms-access.

While looking at your form, go:

records->filter->filter by form.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top