View Single Post
  #3  
Old August 12th, 2004, 11:46 PM
Marc
external usenet poster
 
Posts: n/a
Default Enabled/Disabled text boxes

Thanks Reggie!

Marc

-----Original Message-----
Marc, sure is. In the afterupdate event of the combobox

just do something like

Private Sub cboMyComboBox_AfterUpdate()
If Me.cboMyCombo = "this" Then
Me.myTextBox.Enabled = False
Else
Me.myTextBox.Enabled = True
End If
End Sub

Note: If the textbox is located on a subform you will

have to refrence it like so:

Me.MySubform.Form.myTextBox.Enabled=False

Hope it helps!
--
Reggie

----------
"Marc" wrote in

message
...
Hi,

Is it possible to make a text box in a form enabled or
disabled depending on what choice is made in a combo box
on the form?

I am in Access 2000.

Thanks,

Marc



.