how to pass values from a form to another

[pjustin1]

I use a form to open another form and I want to pass values from the first form over to the second form and display it on the second form.. is this possible?

I guess I need to use VBA, can someone give a simple example for this?

Thanks!

 

[Chris RR]

This code would go in the On Click event for the button that opens the second form:
Dim DocName As String
DocName = "fFormTwo"
'I use acAdd, you may want acEdit here...
DoCmd.OpenForm DocName, , , , acAdd

'Set Defaults for Approver's Id & other stuff...
Forms![fFormTwo]![txtID_APPROVER] = me.txtCurrUserID
Forms![fFormTwo]![txtSOMETHING_ELSE]=
me.txtThisAndThat

[This message has been edited by Chris RR (edited 11-14-2001).]