IanT
12-10-2001, 05:00 AM
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.
|
View Full Version : Mandatory fields IanT 12-10-2001, 05:00 AM 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. saintsman 12-10-2001, 05:32 AM In your table design, set the 'required' property to 'yes'. LQ 12-10-2001, 07:03 AM 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 |