Multiple subForms & Tables

[Guest]

How do I change which subform is displayed using a combo box?
Background Info:
I have a single Form displaying basic equipment info from the same table,
but i want to add a subform that displays specific info based on the
Equipment Type (Computer-Processor Speed; or Printer-Double Sided)?

 

[John Vinson]

How do I change which subform is displayed using a combo box?
Background Info:
I have a single Form displaying basic equipment info from the same table,
but i want to add a subform that displays specific info based on the
Equipment Type (Computer-Processor Speed; or Printer-Double Sided)?

Two ways:

1. Have two different Forms in the Forms collection; change the
SourceObject property of the subform control in the AfterUpdate event
of the combo box.

2. If you can use the same basic form layout, just with different
contents, you can change the Subform's Form object's Recordsource
property to a different query.

John W. Vinson[MVP]

 

[J. Goddard]

Try: me![sub-form field].sourceobject = "Combo Box value"

Be sure you get master and child field names right.

John