Filter subform based on either 1 or 2 combo boxes in main form

[Lisette]

Hi, I have a form with a combo box of projects, when a Project is selected the second combo box updates with a list of ProjectAreas, which can then be selected.

At present the subform updates when the Project combo box is selected and the subform shows a list of hard drives where data from this Project is stored.

Relationships have been created between Project (Id) to ProjectArea table , ProjectArea (Id) to HardDrive table.

I would like to be able to either just use the Project combo box to show all data under that project or also use the ProjectArea combo box to carry on to filter the data down to a specific ProjectArea.

I haven't used VBA for a any of this yet, but am happy do do it - although a little rusty!

All help appreciated.

Lisette

 

[Beetle]

In VBA you can build a string, based on the choices made (or not made) in the combo boxes, that can be used to filter the record set. There is an example of this method here;

http://allenbrowne.com/ser-62.html