Filtering using combos

S

Steve A

Hi,
I have a form (FilterCards) which has a continuous form setup, thus showing
all my records in a table (Cards).

The form is made up of...

ID Name Price Category Location

However Category and location are combo boxes which link to a related field
on category and location tables respectively.

This is all working fine, but now I want to add a combo box and a button in
the header of the form so that I can choose a location from the header combo
then click on the button to filter the form by the value of the combo box.

I want to have the combo box referencing the same as the location within the
body.

Is this possible? If so, how?

Thanks in advance.

Steve A
 
Top