how do i append a forms current record into a new form when launch

F

fishy

I have two forms that are operated by different teams, what I am trying to
do is capture the data from frmleaddata and populate some of the common
fields in the new form frmwme the chk box that launches using the following
code:

Private Sub chkwme_AfterUpdate()

Me.Refresh
DoCmd.OpenForm "frmWME", acViewNormal, , "[ID]=forms!frmLeadData!txtID"

End Sub

This frmwme will then allow me to edit and save afterwards.

A relative newbie so idiot proof help if available would be preferred.
 
Top