Button to copy fields then a button to paste them into another record.

[GraemeG]

Hello.
I have asked something like this previously. But I was merely looking as I was not upto the stage of incorporating it. I am now at that stage, but would like more clarity if anyone can help please.

What do I need to do to be able to copy certain fields in one record via a copy butto and then go to another existing record and by clicking another button, Paste, will fill in the copied fields.



I have different fields like:
Survey Date - Which is a date selector.
Surveyor - Which is a combo box.
KitchenRenewYear - Which is a text box.

If Someone was willing to start me off with how to do this then I can use the code for the remainder of the fileds I want to copy.

This would be much appreciated.
Thanks

[pbaldy]

Set up global variables for your values. In your copy button:

VariableName = Me.TextboxName

in the paste button

Me.TextboxName = VariableName

[ajetrumpet]

maybe throw the vals into globals?

global val1
global val2
global val3

button_event()

val1 = me.control1
val2 = me.control2
val3 = me.control3

now you have them in memory. get them whenever you want. right?

[GraemeG]

Set up global variables for your values. In your copy button:

VariableName = Me.TextboxName

in the paste button

Me.TextboxName = VariableName

So is this just a case of creating a button and adding all the Fields I want to copy as:
VariableName = Me.TextboxName
and visaversa for paste button?

Or is there some code for stating copy?
I.e

Private Sub btnCopy_Click()
DoCmd.RunCommand acCmdCopy
VarSurveyor = Me.cboSurveyor
VarSurveyDate = Me.txtSurveyDate
End Sub

[pbaldy]

For what you've described, there's no built in function. You'll need to create and code both buttons.

[GraemeG]

For what you've described, there's no built in function. You'll need to create and code both buttons.

Sorry but I am out of my depth with this one.
Where and how would I start?

[pbaldy]

Declare your variables either in a standard module or the top of the form's module, depending on whether you want them available outside this form. Create buttons and add the code.

[GraemeG]

Declare your variables either in a standard module or the top of the form's module, depending on whether you want them available outside this form. Create buttons and add the code.

Sorry I dont understand what is meant by declaring the variables?
I.e. How would I declare the following:
1) Survey Date - Which is a date selector.
2) Surveyor - Which is a combo box.
3) KitchenRenewYear - Which is a text box.

[pbaldy]

Why don't you look up "variables" in VBA help? There's a lot more info there than I can type here.

[ajetrumpet]

Why don't you look up "variables" in VBA help?

LOL! Because even semi-newbie's haven't reached 100% productivity.

Sorry, had to. Woohooo, Paul! Nice one.

[ajetrumpet]

DECLARE means, in code:

DIM variableNameHere AS dataTypeNameHere

CAP words are literal/verbatim. Proper case words to be replaced by your own.