Link Child/Master Fields from Three Combo Boxes in Subform

[DocB1973]

I have a Master form that has three combo boxes. I have an embedded subform
and have added the three fields in the link child fields and the link master
fields of the subform place holder. My problem is that all three combo boxes
must have a value before I get any records to display in the subform. I
would like the users to have the ability to select a value from combo box 1
and leave the other two blank (or any of the other alternatives) and display
the records in the subform.

The records in the subform display when I link on only one of the combo
boxes. Any help would be much appreciated. Please let me know if you need
further detail.

 

[Tom van Stiphout]

On Tue, 30 Dec 2008 12:01:33 -0800, DocB1973

You may need to set the LinkMaster and LinkChild properties
programmatically, depending on which comboboxes have a selected value.

-Tom.
Microsoft Access MVP

 

[DocB1973]

Thank you for your reply. Would you be able to give me an example of how
this could be done? I appreciate all the help you can give me.