I am stumped on how I can enable a command button while typing in a field
I have frmunits that has 3 fields Year, Model, Vin#. I want the cmdwarranty button disabled unless there is something entered in on of these boxes. I currently have this
If Not IsNull(Year) Or Not IsNull(Model) Or Not IsNull(Vinnumber) Then
Me.cmdwarranty.Enabled = True
End If
But no matter what event I try I can't seem to make the button enable and disable correctly. The form is set for continuous and the cmdwarranty button is located in the form header which shouldn't matter. Also I will need to disable the button once someone moves to a new record. To do this I think all I need is the oncurrent event of the form to have this
If IsNull(Year) Or IsNull(Model) Or IsNull(Vinnumber) Then
Me.cmdwarranty.Enabled = False
End If
Can someone please help me with this.
I have frmunits that has 3 fields Year, Model, Vin#. I want the cmdwarranty button disabled unless there is something entered in on of these boxes. I currently have this
If Not IsNull(Year) Or Not IsNull(Model) Or Not IsNull(Vinnumber) Then
Me.cmdwarranty.Enabled = True
End If
But no matter what event I try I can't seem to make the button enable and disable correctly. The form is set for continuous and the cmdwarranty button is located in the form header which shouldn't matter. Also I will need to disable the button once someone moves to a new record. To do this I think all I need is the oncurrent event of the form to have this
If IsNull(Year) Or IsNull(Model) Or IsNull(Vinnumber) Then
Me.cmdwarranty.Enabled = False
End If
Can someone please help me with this.