Copy form text box data to another record

[stu_C]

Hello
If I want to copy the multiple field data details from the current record to a new record but only certain fields how do I do this using a button?

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

Help with this would be greatly appreciated

[orange]

Cross posted with responses at https://www.access-programmers.co.uk...d.php?t=307038
Stu did you look at the Allen Browne materials suggested on the other forum??

Stu,
When you cross post, it is considered proper etiquette/netiquette to advise readers that you have done so.
And to provide a link(s) to the other post(s).

Here's why.

[mike60smart]

Hi Stu

You can use something along these lines

' add new record in tblName
CurrentDb.Execute "INSERT INTO tblName ( Field1, Field2, Field3, Field4 ) " _
& "Values ( " & Me!Field1 & ", " & Me!Field2 & ", " & Me!Field3 & ", '" & Me!Field4 & " );", dbFailOnError