Any other way other than copy and paste?

[wind54surfer]

Hi all,

I am a newbie and need to copy a calculated result from a textbox ("txtAmountEnter") to another ("InvAmount") whose control source is a field in a table (therefore not able to hold a calculation).

I have been using:
========================================
DoCmd.GoToControl "txtAmountEnter"
' Copy content
DoCmd.RunCommand acCmdCopy
DoCmd.GoToControl "InvAmount"
' Paste content
DoCmd.RunCommand acCmdPaste
========================================
I run this event on the On Exit of another previous textbox.
It worked OK until recently, but now I am getting error:
"The command or action paste is not available......."
I know my way is not very good but I don't know any other way.

Can someone please help me do it right.

Thanks a lot on advance,
Emilio
Access 2003

 

[ShaneMan]

Hi all,

I am a newbie and need to copy a calculated result from a textbox ("txtAmountEnter") to another ("InvAmount") whose control source is a field in a table (therefore not able to hold a calculation).

I have been using:
========================================
DoCmd.GoToControl "txtAmountEnter"
' Copy content
DoCmd.RunCommand acCmdCopy
DoCmd.GoToControl "InvAmount"
' Paste content
DoCmd.RunCommand acCmdPaste
========================================
I run this event on the On Exit of another previous textbox.
It worked OK until recently, but now I am getting error:
"The command or action paste is not available......."
I know my way is not very good but I don't know any other way.

Can someone please help me do it right.

Thanks a lot on advance,
Emilio
Access 2003

How about:
Me.InvAmount = Me.txtAmountEnter
In the Exit event?

 

[wind54surfer]

Thanks a lot.

It shows how little I know!

 

[ShaneMan]

Thanks a lot.

It shows how little I know!

You welcome. Glad I could help.

Shane