In the After Update event of the Option Group that your buttons are in,
enable or disable the combo box:
(let's assume your options are 1 and 2, and 1 means enable the combo box and
2 means disable it:
Me.MyComboBoxNameHere.Enabled = Me.MyOptionGroupNameGoesHere = 1
> Hi,
> I have an option group on my form with 2 option buttons. Then I have a
[quoted text clipped - 8 lines]
>
> Thank you
Confused - 18 Oct 2005 19:59 GMT
Thank you I will try that and then I will let you know how it worked!
> In the After Update event of the Option Group that your buttons are in,
> enable or disable the combo box:
[quoted text clipped - 16 lines]
> >
> > Thank you
Confused - 18 Oct 2005 20:13 GMT
That did exactly what I needed it to do ........Thank you Very Much.
Now If I could just trouble you for one other problem I am having and can't
seem to find the answer to. I didn't create my combo box using the wizard.
How can I get the combo box to look up a record in my table with out going
through and recreating it in a wizard? Thanks for all your help again.
> In the After Update event of the Option Group that your buttons are in,
> enable or disable the combo box:
[quoted text clipped - 16 lines]
> >
> > Thank you