Can you enable or disable a text box in a form based on criteria

[williekay]

I have a form that has a field called HM. HM is either going to be a number or an X. I have a combo box that is set to yes or no. I want to disable the combo if HM = X and enable it if Isnumber(HM).

Willie

 

[Eupher]

Sure. Create an event procedure in the AfterUpdate event of the HM textbox, something like this:

Me!ComboName.Enabled = IsNumber(Me!HM)

HTH,

Ken S.

 

[ZmrAbdulla]

OR little elaborated

Private Sub HM_AfterUpdate()
    If IsNumeric(Me.HM) Then
        Me.ComboName.Enabled = True
    Else
        Me.ComboName.Enabled = False
    End If
End Sub

________________________________________________________________________
Zameer Abdulla
Visit Me
No two children are alike - particularly if one is yours and the other isn't.

 

[williekay]

Is After Update going to work if the HM text box is a calculated control.

=IIf(DMin("[ID1]","[Production Schedules]","HNumber = " & [HNumber] & " AND SJoin = '" & [Sjoin] & "'")=[ID1],DSum("[PourWeight]","[Production Schedules]","HNumber = " & [HNumber] & " AND SJoin = '" & [Sjoin] & "'")+[KBw],"X")

Willie

 

[ZmrAbdulla]

Try mys solution with OnCurrent Event of the form.

________________________________________________________________________
Zameer Abdulla
Visit Me
No two children are alike - particularly if one is yours and the other isn't.

 

[Eupher]

Right. AfterUpdate does not fire if the data is changed programatically.

Ken S.