Combo box to filter(4 options).. where do i start?

[wazza]

Hi

I have created a form based on a query showing records in a tabular format - i want to use a combo box on a form to filter or somehow only show the records according to the combo box selection. Ideally..The user could select a value from the combo box and only those records containing the field value are displayed in the tabular format...

Im not too sure where to start... and getting to grips with the Vbcode

I have set up the combox box and got its source data from another table (so ive only got one value of each option)....



Thanks

 

[dcx693]

You're off to a good start. One way to proceed would be to base the form on a query. The query would reference the combo box you just created in a criteria. Seems kind of circular, but it isn't. The form records depend on the query, which depend on the combo box (which doesn't depend on the form records).

Here's an article that will get you off to a good start: Customizing Access Parameter Queries