Filter Certain Records based off of users selection

[dragongunner0351]

Hello all I have an Access 2003 DB,

I have a table that holds Machine Lead information.

Fields include: Id, CompanyName, MachineType, Quoted, DateQuoted, and Status.

I want to have a form that has predefined parameters (via list boxes or drop down list) for the user to select to help filter the records in the table.

FOR EXAMPLE: Because a customer can have multiple machine quotes in the system the endusers are requesting the following: A drop down list for the CompanyName, Then a drop down list for the MachineType.

I am familiar with developing a query to do this on one selection. However the endusers would like to be able to filter the records based off of more than one selection to narrow the results even further.

Any suggestions or recommending links on this technique would be greatly appreciated.

Thanks to all in advance.

 

[dhookom]

What are the users opening based on the filter, a report or form?

What method do you use to "do this on one selection"?

Do you expect the 1st combo box to filter the 2nd combo box?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[dragongunner0351]

Thanks for the reply dhookom

The users will be opening a form based off of the criteria they select.

As for the method of selection I was using LIKE

I would like to filter the 2nd combo off of the first but it would not be entirely necessary at this point.

 

[dhookom]

You should be able to find an example of cascading combo boxes at

http://www.rogersaccesslibrary.com/TableOfContents3.asp#C.

There are several methods of using "like". We don't know if you have this in your query or are you using it in the where condition of DoCmd.OpenForm.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[dragongunner0351]

Thank you for the reference, I'll give it a shot