M Matizo Registered User. Local time , 19:51 Joined Oct 12, 2006 Messages 83 Dec 18, 2009 #1 hello, As in the title, I've created unbounded form to add new record (job). How do I make the ClientID field required? Thanks!
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 AWF VIP Local time Today, 12:51 Joined Aug 29, 2005 Messages 8,262 Dec 18, 2009 #2 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; Code: If IsNull(Me.ControlName) Then MsgBox "Please enter a ClientID" Me.ControlName.SetFocus Exit Sub End If
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; Code: If IsNull(Me.ControlName) Then MsgBox "Please enter a ClientID" Me.ControlName.SetFocus Exit Sub End If
M Matizo Registered User. Local time , 19:51 Joined Oct 12, 2006 Messages 83 Dec 18, 2009 #3 Thank you John, I added your code and it works as it should Cheers!
John Big Booty AWF VIP Local time Today, 12:51 Joined Aug 29, 2005 Messages 8,262 Dec 18, 2009 #4 Good Work