Group:  Microsoft Access ยป microsoft.public.access.forms
Thread: Link Child/Master Fields from Three Combo Boxes in Subform

Link Child/Master Fields from Three Combo Boxes in Subform
DocB1973 12/30/2008 8:01:33 PM
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.
Re: Link Child/Master Fields from Three Combo Boxes in Subform
Tom van Stiphout <tom7744.no.spam[ at ]cox.net> 12/31/2008 4:37:03 AM
On Tue, 30 Dec 2008 12:01:33 -0800, DocB1973
<DocB1973[ at ]discussions.microsoft.com> wrote:

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

-Tom.
Microsoft Access MVP


[Quoted Text]
>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.
Re: Link Child/Master Fields from Three Combo Boxes in Subform
DocB1973 12/31/2008 1:53:01 PM
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:

[Quoted Text]
> On Tue, 30 Dec 2008 12:01:33 -0800, DocB1973
> <DocB1973[ at ]discussions.microsoft.com> 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.
>

Home | Search | Terms | Imprint
Newsgroups Reader