var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Field Retains focus on null
I have a database which is populated with data from another database. The records are then edited by the end-user in a data-entry form.
I'm trying create a control on a forum whereas the user isn't able to proceed if the value is null.
I've written code like this:
If IsNull(Forms![Census Tracking]!DateReferredUW) = True Then
MsgBox "Please Enter a Value"
I get the message box to come up, but the user is allowed to go to the next field after clicking "OK" on the message box.
How can I get the field to retain focus? A loop of some sort?
In which event did you put the code?
I've tried it on "BeforeUpdate" and "OnExit"
Use the on Exit event
Private Sub txt_Para1_Exit(Cancel As Integer)
If IsNull(txt_Para1) Then
Cancel = 1
this is exactly what i needed it to do! thank you so much.