RecordsGoToNew

[dustinalexander]

Is there anyway to create a button with the RecordsGoToNew function only choosing specific fields and not others?

 

[Wozzzzza]

dont know about others but i need this question elaborated on to include more detail.

 

[Galaxiom]

A new record is one that has no values in any field. I you are wanting to insert a value in an empty field of an existing record it would seem likely that you have not structured your database correctly.

Please elaborate your table structure.

 

[Khalid_Afridi]

Keeping the default value in certain field/s will automatically insert that value in the those fields whenever there is new recored created.

 

[dustinalexander]

Sorry let me elaborate more.

I have a Access Form I created in which at the bottom of the form their is a button that when pressed will copy all the data just entered in the current record and place it into the next new record.

When i created the button the command it used to do that was the RecordsGoToNew command.

The problem is I want it to only copy certain fields when that button is pressed not every field which is what is happening now.

 

[Khalid_Afridi]

make unubound textbox controls on your form and get the data of your desire fields on form current event i.e
txtControl1.value = me.Field1
txtControl2.value = me.Field2
txtControl3.value = me.Field3

on Button Click event:
goto new record and reverce the contols values

me.Field1.value = txtControl1.value
me.Field2.value = txtControl2.value
me.Field3.value = txtControl3.value

Hope this help