Ramudo

If your table structure is such that you could have multiple records in
which you would "reuse the data", your tables may need further
normalization. In a spreadsheet, you'd 'copy' data from one record to the
next. It is quite rare to need to do that in a well-normalized relational
database.

If you'll provide an example or two of the type of data you'd want to
"reuse", and a description of your current table structure, folks here may
be able to offer their experience/ideas.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"ramudo" wrote in message
...
I am a novice on Access. I created a form that adds records to a table. I
included a button that adds the record to the table. When I click the
'Add
Record' button, the fields clear. Is there a way to have Access not clear
the fields so that I can reuse the data on some of the fields? Thank you
for
your help.
Ramudo