I IanT Registered User. Local time Today, 12:45 Joined Nov 30, 2001 Messages 191 Dec 10, 2001 #1 I want to have a form that will not go to a new record unless specific data is inputed. i.e. if the date field has no data showing a message would inform user that data is required.
I want to have a form that will not go to a new record unless specific data is inputed. i.e. if the date field has no data showing a message would inform user that data is required.
S saintsman Registered User. Local time Today, 12:45 Joined Oct 12, 2001 Messages 138 Dec 10, 2001 #2 In your table design, set the 'required' property to 'yes'.
L LQ Registered User. Local time Today, 12:45 Joined Apr 5, 2001 Messages 145 Dec 10, 2001 #3 You could put something in the BeforeUpdate event of the form that would check for the blank field and then produce a msgbox. Something like If IsNull(me.yourtxtboxname)or Len(yourtxtboxname)=0 Then Msgbox "Enter a date!" Else.... End if
You could put something in the BeforeUpdate event of the form that would check for the blank field and then produce a msgbox. Something like If IsNull(me.yourtxtboxname)or Len(yourtxtboxname)=0 Then Msgbox "Enter a date!" Else.... End if
