Copy and Paste data between two forms

[NadiaVKhan]

Hello.

I have two forms. frmAlpha and frmBeta.

There is a button on frmAlpha that opens frmBeta in a dialogue box. I want this button to ALSO copy the data in field txtFoodNameA in frmAlpha to txtFoodNameB in frmBeta.

What is the code I would use for this?

I imagine it should be something along the lines of

Sub
frmAlpha.txtFoodNameA.value = frmBeta.txtFoodNameB.value
End Sub

 

[CJ_London]

to refer to controls in other forms, see this link

http://access.mvps.org/access/forms/frm0031.htm

 

[missinglinq]

Is this a New Record in frmBeta? If so, you can use the OpenArgs argument, like this, where AlphaButtonName is the actual name of your Command Button:

In Form frmAlpha:

Private Sub AlphaButtonName_Click()
  DoCmd.OpenForm "frmBeta” , , , , , Me.txtFoodNameA	
End Sub

Then, in frmBeta:

Private Sub Form_Load()
  If Nz(Me.OpenArgs, "") <> "" Then
    DoCmd.GoToRecord , , acNewRec
    Me.txtFoodNameB = Me.OpenArgs
  End If
End Sub

Linq ;0)>

 

[NadiaVKhan]

Yes. It is a new record in frmBeta. However, I recieve a "Run-Time error '13': type mismatch" error when I click the button on frmAlpha

 

[missinglinq]

Sorry...missed a comma, I think! Instead of

DoCmd.OpenForm "frmBeta” , , , , , Me.txtFoodNameA

try

DoCmd.OpenForm "frmBeta” , , , , , , Me.txtFoodNameA

Linq ;0)>