Opening one form from another on the same record

[Rusty]

Help me!!??

I have a form "frmCommercialTrials" with a field called "cboProjectRef", (the control source of which is [ProjectReference].

I have a button on this form and when I click on it I want it to open a form called "frmFundingDistribution" on the current record of the original form, (this form also has a field called "cboProjectRef", - the control source of which is [ProjectReference]).

I can get the form the open easy enough but cannot get it to do the above. I can pull this off when opening a report by using the code below. Do I need to use something similar?

Rusty

Private Sub cmdCheckCost_Click()

DoCmd.OpenReport "rptEventPaymentsCrossCheck", acPreview, , "[ProjectReference] like '" & Me![cboProjectRef] & "'"

End Sub

 

[Mile-O]

Help me!!??

Is that a question or an exclamation?