RonnieDobbs
MIS
Hello I have the following code in my forms before update in order to check if there is text in the field:
If IsNull(Confirmed) Then
MsgBox "Data is required."
Confirmed.SetFocus
Cancel = True
End If
However, when I exit my form via the close form button, a message says:
"data entry required" which is great, I click ok to enter text but the form closes???
The confirmed field is a required field in the table properties, However, a message box only comes up when you physically click on the field and TAB out of it. If you click on the Field and click out the message does not come up and you can close the form...
any Suggestions???
If IsNull(Confirmed) Then
MsgBox "Data is required."
Confirmed.SetFocus
Cancel = True
End If
However, when I exit my form via the close form button, a message says:
"data entry required" which is great, I click ok to enter text but the form closes???
The confirmed field is a required field in the table properties, However, a message box only comes up when you physically click on the field and TAB out of it. If you click on the Field and click out the message does not come up and you can close the form...
any Suggestions???