I am new to Access and was wondering when entering date in a form, then going
to a new record in that form to enter more date, can you duplicate the same
data you just entered in the previous record? Ex: Customer - date - order#
and amount are fields in my form. I have a customer 'A' that orders several
items. Can I duplicate customer 'A' and the date without having to retype
the same info in every record?

If you database is designed correctly, you do not have all the information
in that one row of data. That is one of the main differences between a
database and a spreadsheet.

A customer table handles all the customer information, and orders table uses
the customer ID from the customers table and handles all the order header
information (CustomerID, Date, etc.), and an order details table handles the
items on the order.

For an example, have a look at the Northwind sample database that came with
Access.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Sandraoc" <(E-Mail Removed)> wrote in message
news:2E36550C-AA69-42E7-B956-(E-Mail Removed)...
>I am new to Access and was wondering when entering date in a form, then
>going
> to a new record in that form to enter more date, can you duplicate the
> same
> data you just entered in the previous record? Ex: Customer - date -
> order#
> and amount are fields in my form. I have a customer 'A' that orders
> several
> items. Can I duplicate customer 'A' and the date without having to retype
> the same info in every record?