copy field data from one record to another

[stu_c]

Hi all
I have the following fields in a form

CustomerID
Forename
Surname
Address
DeliveryAddress
etc

If I want to copy the field data details from the current record to a new record how do I do this using a button?

 

[June7]

Re: Copy Field data from one record to another

More than one way to accomplish. Have you done Google search? Fairly frequent topic.

But why are you duplicating all that customer info? Why not just save CustomerID?

 

[isladogs]

Re: Copy Field data from one record to another

You shouldn't do this

In theory, you could use an append query filtered to the current record.
However if CustomerID is the primary key field you won't be able to do so as duplicates are not allowed
This raises the obvious point that the customer name details should only exist once in a Customers table with a separate table using CustomerID as a foreign key for each delivery address. Similarly each order would be placed in a Orders table linked to the above

 

[stu_c]

Re: Copy Field data from one record to another

Hello thank you for the above
I have about 11 fields I need to copy across but didn't want to write them all down so only gave these as a example (bad example I agree) I need to do this for repeat items etc would be much easier just to have one button to copy this details onto another new record

 

[stu_c]

Hi all
I have the following fields in a form

Field1
Field2
Field3
Field4

If I want to copy the field data details from the current record to a new record how do I do this using a button?

 

[Gasman]

Save the required controls to variables
Create new record and populate the controls from the variables.?

 

[stu_c]

That means nothing to me ��

 

[jdraw]

stu,

Please give us more info about the database. Your database has tables with fields. Your form is bound to a table? Your requirement is to move some field values from one record to another using the button click event on the form.

Here is a method to carry over field value(s) from one record to another from Allen Browne.
Good luck.

 

[stu_c]

Hello
yes tables have fields
TBLDetails
Field1
Field2
Field3
Field4

the form fields are bound by the table
TextBox1
TextBox2
TextBox3
TextBox4

I have 11 or so fields but would only like certain fields to be copied across when a command button is pressed

stu,

Please give us more info about the database. Your database has tables with fields. Your form is bound to a table? Your requirement is to move some field values from one record to another using the button click event on the form.

Here is a method to carry over field value(s) from one record to another from Allen Browne.
Good luck.

 

[isladogs]

I've moved the first four posts from the thread you deleted earlier as they relate to the same topic and the replies are pertinent.

As a simple courtesy, please do not delete threads where there have been replies as the info may be useful to other members