Auto-filling fields in a new record from existing record

  • Thread starter Thread starter Crapsjack.com
  • Start date Start date
C

Crapsjack.com

I have an order form that keeps individual records of
each order we take. We are now lucky enough to have
repeat customers, but have to manually enter all their
info into a new record in the form each time they order.
I'm wanting to put a button on the form that will take
the fields I want (name, address, etc.) from a current
record and auto-fill a new record with that data. I have
no clue where to look, or where to start. Anyone out
there feel like helping a guy out?

Thank you.

Using:
Win XP
Access 2000
 
I have an order form that keeps individual records of
each order we take. We are now lucky enough to have
repeat customers, but have to manually enter all their
info into a new record in the form each time they order.
I'm wanting to put a button on the form that will take
the fields I want (name, address, etc.) from a current
record and auto-fill a new record with that data. I have
no clue where to look, or where to start. Anyone out
there feel like helping a guy out?
Click to expand...

Well... I don't know if this will help or not, but I'd suggest a
complete redesign of your tables.

Take a look at the Orders form in the NORTHWIND.MDB sample database.
You'll see that there is a Customers table (where every customer gets
entered once, and once only) related to an Orders table, which
contains the CustomerID (but no other customer information).

This is a very basic principle of relational databases: enter data
ONCE, and once only; then link to it using a query.

If you don't feel up to a redesign then you'll need to get into some
VBA (Visual Basic for Applications) code and run an Append query -
probably just about as much work, but if you wish post back with a
description of your table structure and someone can probably help.
 
Back
Top