If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Link Child/Master Fields from Three Combo Boxes in Subform
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. |
#2
|
|||
|
|||
Link Child/Master Fields from Three Combo Boxes in Subform
On Tue, 30 Dec 2008 12:01:33 -0800, DocB1973
wrote: You may need to set the LinkMaster and LinkChild properties programmatically, depending on which comboboxes have a selected value. -Tom. Microsoft Access MVP 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. |
#3
|
|||
|
|||
Link Child/Master Fields from Three Combo Boxes in Subform
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. "Tom van Stiphout" wrote: On Tue, 30 Dec 2008 12:01:33 -0800, DocB1973 wrote: You may need to set the LinkMaster and LinkChild properties programmatically, depending on which comboboxes have a selected value. -Tom. Microsoft Access MVP 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. |
Thread Tools | |
Display Modes | |
|
|