access forms with default null values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have set up a form to enter data. I would like each of the fields to have
a null value when I start. Currently, there is a value in each of these
fields. Can anyone tell me why?

Thanks,
Trace
 
Set the Data Entry property of the form to True. It will then only allow you
to enter new records.
Unless the Data Entry property of a form is True, it will always open to the
first record in the recordset. That is where your form is getting its values
from.
Controls on the form for a new record, unless they have a Default Value are
Null.
 
Hi Trace,

you are probably not on a new record...try pressing CTRL+

new records are entered at the end

if you do not want the form to display any old records, change the
DataEntry property of the form to Yes

Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
At the moment, the whole thing seems to be stuck. I can't enter anything in,
I can't choose anything that I currently have, etc. Ctrl+ doesn't seem to
work either. I've tried it both ways wrt the data entry Yes vs. No. It
doesn't seem to be making a difference.
 
you may be using a non-updateable recordset

is your form based on a query that links multiple tables?

When you set the DataEntry property of the form to Yes, what happens
when you open it?

Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
Back
Top