Unbound form - make a required field

[Matizo]

hello,

As in the title,
I've created unbounded form to add new record (job). How do I make the ClientID field required?

Thanks!

 

[John Big Booty]

Given that this form is unbound, I'm presuming that you have some code that you are using to commit this date to a table.

At the start of the code put the following;

If IsNull(Me.ControlName) Then
     MsgBox "Please enter a ClientID"
     Me.ControlName.SetFocus
     Exit Sub
End If

 

[Matizo]

Thank you John,

I added your code and it works as it should

Cheers!

 

[John Big Booty]

Good Work