Solved

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

Posted on 2013-01-20
2
1,251 Views
Last Modified: 2013-01-20
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)
0
Comment
Question by:bill201
2 Comments
 
LVL 39

Assisted Solution

by:als315
als315 earned 250 total points
ID: 38798355
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
 
LVL 61

Accepted Solution

by:
mbizup earned 250 total points
ID: 38798384
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

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

This article describes some very basic things about SQL Server filegroups.
Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now