Solved

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

Posted on 2013-01-20
2
1,507 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 40

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

10 Questions to Ask when Buying Backup Software

Choosing the right backup solution for your organization can be a daunting task. To make the selection process easier, ask solution providers these 10 key questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

628 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