required controlbox

[ariansman]

I have a table named kidsjobs. There is a field in this table named kharidar which is not a required field.


A form has been made on this table. It has a control box named kharidar, bound to the above mentioned field named kharidar. I want to design the form so that the user cannot close or move to next record, unless the controlbox kharidar in the form is not blank. i dont want to make the field in the table required. The names are actual. Please help me have the vba code or anything that works to get this task.
thank you

[Bob Fitz]

Use the forms BeforeUpdate event to check if kharidar is null. The event can be cancelled with Cancel = true if the validation fails at which point you may want to display a message box to advise the user.
EDIT:
Is this some kind of school home-work?

[Bob Fitz]

Perhaps something like:

Private Sub Form_BeforeUpdate(Cancel As Integer) 
     If IsNull(Me.kharidar) Then
        MsgBox "Enter data for 'kharidar' ", , "DATA REQUIRED"
        Cancel = True
    End If
End Sub

[ariansman]

thank you. it worked

[Missinglinq]

This just begs the question...'Why do you want a Field to be Required...but not be Required?

Linq ;0)>