how to prevent users from leaving a specific field empty in a form in access 2010

hi

i have a Continuous Form in access 2010 that based on a query

this form have 2 fields
OrderDate
SupplierName

and i want to prevent users from to update this field if the supplierName is empty how can i do it (in the form with vba)
bill201Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
mbizupConnect With a Mentor Commented:
In the form with vba..

Use the form before update event.

If me.suppliername & "" = "" then
     Cancel = true
     Msgbox "fill in supplier name"

End if
0
 
als315Connect With a Mentor Commented:
If you set Required property for this field in source table to Yes, you will not be able to add record with empty field
0
All Courses

From novice to tech pro — start learning today.