Default Values

[Tee See]

When inputing data thru a form to a table I have a button which closes the
form and which I wish to keep as that. How can I keep the last entry in the
form as the default when I reopen the form?

 

[Jeff Boyce]

Are you saying you want the last record entered to be displayed on the form,
or that you want the values recorded for the last record entered to be the
(new) default values for the next record to be entered?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Tee See]

Jeff Thanks for the response.
My simple mind is having a problem understanding the difference between the
two options you have given. Are they not the same thing. If I had to choose
one it would be the latter. Thanks again.

 

[Jeff Boyce]

If your form is a data entry-only form, setting the DefaultValue of the
various controls before you leave the form means you'll have these (new)
default values when you next open the form (for data entry).

If your form is bound to the data in the underlying table, and is NOT only
for data entry, you could decide you wanted the form to open pointed at the
first record in the table, the last record in the table, or the record that
was entered on 1/2/2006 (provided your table includes a DateEntered field).

The former reduces the number of keystrokes needed to enter a new record
(but only if new records are essentially identical to old records -- and
this is a BAD IDEA in a well normalized database design).

The latter lets the user see where s/he left off.

Regards

Jeff Boyce
Microsoft Office/Access MVP