How do I make a form object's properties dependent on another obj.

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

Guest

I'm trying to build an Access 2003 form where a combo box is enabled if a
specific value is selected in the option group that immediately precedes the
combo box in the tab order, but is disabled if that value is NOT selected in
the option group. Does anyone know how to do this easily?
 
Hi, Bill.

Sure. In the AfterUpdate event of the combo box and the OnCurrent event of
the form,

If Me!MyOptionGroup = CertainValue Then
Me!MyComboBox.Enabled = True
Else
Me!MyComboBox.Enabled = False
End If
 
Works great! Thanks a million!

Sprinks said:
Hi, Bill.

Sure. In the AfterUpdate event of the combo box and the OnCurrent event of
the form,

If Me!MyOptionGroup = CertainValue Then
Me!MyComboBox.Enabled = True
Else
Me!MyComboBox.Enabled = False
End If
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dependent forms 3
Access How Current page of a form Read Only 2
List all Form Objects problem 5
Subform dependent combo box 4
Unbound option groups and form's RecordSource in Access 2007 2
Make a sub form visible with a combo box selection 4
filter query on combo box in a continuous subform 0
Subordinate Combo Boxes 3

Back
Top