Multiple subForms & Tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

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)?
 
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)?
Click to expand...

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]
 
Try: me![sub-form field].sourceobject = "Combo Box value"

Be sure you get master and child field names right.

John
 
Back
Top