From: Angela on
Thanks for the link Doug. I tried them but get referential errors in the
form's on current event for codes. I don't know what the problem is because
the same code works in the AfterUpdate event.

"Douglas J. Steele" wrote:

> Controls on subforms are always referred to via the parent form. See
> http://www.mvps.org/access/forms/frm0031.htm at "The Access Web" for
> details.
>
> Note that depending on how the forms were added as subforms, the name of the
> subform control may be different than the name of the form being used as a
> subform. It's the name of the subform control you need to use.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
>
> "Angela" <Angela(a)discussions.microsoft.com> wrote in message
> news:F8702AA3-21B9-4F53-BDE4-F00342782C13(a)microsoft.com...
> > Hello. I'm hoping that someone can help me.
> >
> > I have 2 subforms on separate tabs. Based on a user's input on subform 1,
> > I
> > would like a combo box on subform 2 to be enabled or disabled.
> >
> > Does anyone have a solution? Please let me know. Thanks in advance.
>
> .
>