P
pushrodengine via AccessMonster.com
I’m using the code below to enable “StartPatient†and “EndPatient†textboxes
when “Yes†is entered into the “MultiplePatient†textbox.
Private Sub MultiplePatient_AfterUpdate()
Me.StartPatient.Enabled = (Me.MultiplePatient.Value = "Yes")
Me.EndPatient.Enabled = (Me.MultiplePatient.Value = "Yes")
End Sub
The problem I’m having is when I enter “Yes†or “No†the code behaves perfect,
but if I take the focus away from “MultiplePatient†textbox then come back to
it and remove the entry. As soon as I take the focus away I get a message
“Run-time Error ‘94’: Invalid use of Null.
How do I fix this?
Thanks
when “Yes†is entered into the “MultiplePatient†textbox.
Private Sub MultiplePatient_AfterUpdate()
Me.StartPatient.Enabled = (Me.MultiplePatient.Value = "Yes")
Me.EndPatient.Enabled = (Me.MultiplePatient.Value = "Yes")
End Sub
The problem I’m having is when I enter “Yes†or “No†the code behaves perfect,
but if I take the focus away from “MultiplePatient†textbox then come back to
it and remove the entry. As soon as I take the focus away I get a message
“Run-time Error ‘94’: Invalid use of Null.
How do I fix this?
Thanks