Need to require users to select or enter info in fields on a form

M

manbro

I have SQL tables and cannot require entry from the table and need to require
the user to enter info and in some cases select info from fields in a form.
I already tried the cancel = true function but that wont help if we need to
go in and change data later.
Is there any code that I can use to require specific fields in a form to be
filled out?
 
G

Gary

Open the table in design view and on the properties for the fields you need,
change 'Required' from 'No' to 'Yes'.

This will reflect in the form. It won't allow them to update the record
without putting data in those fields.

hth

Gary
 
M

manbro

I cannot do that since my tables reside on a SQL server not within Access,
thats why I need to set the rules on the form level.
 
R

Ron2005

If it is an already existing table with records, you will FIRST have to
create and run a query to load something in that field. Then you can
change the required option.

Ron
 
R

Rick Brandt

manbro said:
I cannot do that since my tables reside on a SQL server not within Access,
thats why I need to set the rules on the form level.
Click to expand...

Check for missing entries in the form's BeforeUpdate event. Display a message
and set Cancel = True if any fields are missing.

The record will not save unless the provide the entries.
 
Top