Updating property of combo within subform

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

Guest

Please Help!!!
I have a form with a tab control and several pages, each have a subform on
it. When I change, or select something in a combo box on the main page, I
want to update the contents of a combo box which is on a subform on the
second page of the tab control.

Updating a combo box on the main page is simple enough, DoCmd.Requery
("combo1"). I can't seem to figure out how to reference the control on the
subform though.

Any help is greatly appreciated.
 
steve said:
Please Help!!!
I have a form with a tab control and several pages, each have a subform on
it. When I change, or select something in a combo box on the main page, I
want to update the contents of a combo box which is on a subform on the
second page of the tab control.

Updating a combo box on the main page is simple enough, DoCmd.Requery
("combo1"). I can't seem to figure out how to reference the control on the
subform though.
Click to expand...


A more explicit way to requery a mainform combo is
Me.combo1.Requery

For a combo on a subform:
Me.subform.Form.combo2.Requery
Note that the tab control has nothng to do with it.
 
Back
Top