combo box varible

[steve111]

hi,

I have 2 tables and I can create 2 combo boxes in my form to select the information I want in my report and then put an iff statement in my query to see which information in that report


is it possible to create a combo box to look at 2 options then depending on which option you select the correct table list can be ready for selection instead of having 2 combo boxes

that's
steve