Trouble with option groups linking to drop down lists!

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

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
 
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
 
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.
 
Back
Top