Automatically copy from one row to another?

[jas1159]

Hi guys,

Is there a way to copy all data from one row in a table into another automatically?

Today I have columns for example; table ID, Reference number, Name

It would be really useful if i could create a Reference number_V2 and automatically fill my form with data from a specified Reference number that already exists in my table.

At the moment I have to re input all the same information for example contact details for V2 that are already specified under V1.

Any help will be greatly appreciated.

 

[Trevor G]

Hi guys,

Is there a way to copy all data from one row in a table into another automatically?

Today I have columns for example; table ID, Reference number, Name

It would be really useful if i could create a Reference number_V2 and automatically fill my form with data from a specified Reference number that already exists in my table.

At the moment I have to re input all the same information for example contact details for V2 that are already specified under V1.

Any help will be greatly appreciated.

Why do this? Surely the relationships should allow you to have all your contact information in a signle table?

However if you need to do this, then create an append query that can work from your form, based on the record you are on, then it should append (which is a copy of the record).

 

[jas1159]

Thanks for your help Trevor,

I have created the query and it works perfectly.

 

[Trevor G]

Pleased to read you have a working solution.