Link forms

  • Thread starter Thread starter David W
  • Start date Start date
D

David W

Is there a way through VB to set a subforms Link Master and Child Fields
property to the main form.

or is there away to filter only subforms?

I have a form that has 2 subforms, the main form does not have a record
source, it just houses the subforms. The subforms are of 2 different tables.

I am wanting to have the option to filter by 2 different sources through
comboboxes.

I can filter a form, but I cant fiqure out how to filter only subforms
listed on an unbound form.
Any Ideals?
 
David said:
Is there a way through VB to set a subforms Link Master and Child Fields
property to the main form.

or is there away to filter only subforms?

I have a form that has 2 subforms, the main form does not have a record
source, it just houses the subforms. The subforms are of 2 different tables.

I am wanting to have the option to filter by 2 different sources through
comboboxes.

I can filter a form, but I cant fiqure out how to filter only subforms
listed on an unbound form.
Click to expand...


I guess I don't understand, why can't you use the combo
boxes as the Link Master property?

Alternatively, you can use a hidden text box on the main
form as the Link Master property.

If your situation is too complicated for that then you can
use code to set the LinkMaster/Child properties:

Me.subformcontrol.LinkMaster = "combo1"
Me.subformcontrol.LinkChild = "fieldx"
 
Back
Top