Updating property of combo within subform

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

steve p - 22 Mar 2007 17:40 GMT

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.

Reply to this Message

Marshall Barton - 23 Mar 2007 01:18 GMT

>Please Help!!!
>I have a form with a tab control and several pages, each have a subform on
[quoted text clipped - 5 lines]
>("combo1"). I can't seem to figure out how to reference the control on the
>subform though.

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.

Signature

Marsh
MVP [MS Access]

Reply to this Message