Trouble with option groups linking to drop down lists!

[Guest]

Hi,
I have an option group on my form with 2 option buttons. Then I have a
combo box that I need to use to look up a current record on my form. What I
would like to happen is that when I select the 1st option group button I need
it to link to the combo box and enable it. An when I select the second
option group button I need the combo box to be disabled? Can this be done?

I tryed looking through the other responses and questions but none of them
seemed to help me any. If this is a repeat question could you please direct
me the right way.

Thank you

 

[Guest]

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

 

[Guest]

Thank you I will try that and then I will let you know how it worked!

 

[Guest]

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.