Is there a way to only have this message display when they try to enter something into the numAdmitNumber? When I tab or hit enter to go to the next field on the form the message "No Changes Possible" displays. Which they have not really entered anything new into the field but they are just tabbing or entering down to the next field on the form.
This is what I have in the On Key Down event procedure:
Private Sub numAdmitNumber_KeyDown(KeyCode As Integer, Shift As Integer)
If numAdmitNumber.Locked Then
MsgBox "No changes possible"
End If
Also when I first come into the form the field for numAdmitNumber is now greyed out but when I tab down or enter down to the next field the colors go away. Is there a way to keep the colors gray for the field numAdmitNumber no matter what field I am on in the form. The Grey background for the field numAdmitNumber only displays when I click back on the field. I want it to stay grey all the time when there is a value in the field. Another issue is when I go to the next record and that record displays the field numAdmitNumber is not grayed out even though there is a value in the field.
Thanks,
Todd
This is what I have in the On Key Down event procedure:
Private Sub numAdmitNumber_KeyDown(KeyCode As Integer, Shift As Integer)
If numAdmitNumber.Locked Then
MsgBox "No changes possible"
End If
Also when I first come into the form the field for numAdmitNumber is now greyed out but when I tab down or enter down to the next field the colors go away. Is there a way to keep the colors gray for the field numAdmitNumber no matter what field I am on in the form. The Grey background for the field numAdmitNumber only displays when I click back on the field. I want it to stay grey all the time when there is a value in the field. Another issue is when I go to the next record and that record displays the field numAdmitNumber is not grayed out even though there is a value in the field.
Thanks,
Todd