Linked forms

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top