Linked forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to open one form (frmSummary) from another (frmContacts) and pass
data to the second form when it opens. I thought I had the code right, but
it's not working. Not sure if this would make a difference or not, but
ClientCaseInfoID on the first form is held in a combo box that is based on a
query.

Here's the code I'm using:

Private Sub Label43_Click()
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frmSummary"
stLinkCriteria = "[ClientCaseInfoID]= " & Me![ClientCaseInfoID]

DoCmd.OpenForm stDocName, , , stLinkCriteria

Any ideas what's going on?

Thanks in Advance
 
Back
Top