Open to selected criteria in subform

[Debbie37]

I have a form that I set the OnClick event to the following:

Private Sub Form_Click()
Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frmmainform"

stLinkCriteria = "[ReqID]=" & Me![ReqID]
'[ReqID] actually refers to a field name in the subform of frmMainForm
DoCmd.OpenForm stDocName, , , stLinkCriteria

End Sub
However, I want the subform's (frmRequestSubform) field value (ReqID) set to equal the ReqID of the record I select in the first form. If I set the field's value to one in the Main Form [PatientID] it works fine, but when I change it to [ReqID], the subform, it opens empty even when I write the entire path: forms!frmMainForm!frmRequestsubform.Form![ReqID]. What am I doing wrong?

 

[jgoodman00]

but when I change it to [ReqID], the subform, it opens empty even when I write the entire path:

I am unsure what you mean by this. From reading this, it seems like you are trying to say that when you change the ReqID in the Subform, the subform opens blank.

Could you clarify please...

James Goodman MCP

http://www.james-goodman.co.uk

 

[Debbie37]

What I mean is when I change it to look for (match the value) the [ReqID] in the subform it open blank, like this:
Private Sub Form_Click()
Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frmmainform"

stLinkCriteria = "[ReqID]=" & Me![ReqID]
'the above matches criteria in the main form (frmMainForm)

stLinkCriteria = "[ReqID]=" & Forms!frmMainForm!
frmRequestSubform.Form![ReqID] 'when I change it to look at the value for [ReqID] it actually refers to a field name in the subform of frmMainForm, which is what I want

DoCmd.OpenForm stDocName, , , stLinkCriteria

The main form (tblPatient primary key PtID) collects patient demos (name, DOB, etc) while the subform (tblRequest, primary key ReqID) collects realease of information requests for each patient in the main form. So, I have my main form, and a patient lookup form that allows the user to type in a patient name which populates the list box on the same form. After selecting the patient in the list box (populated with search results) the AfterUpdate property opens a form listing each realease record for that selected patient. The last part of this is the OnClick event of that form opening the main form matching the [ReqID]in both the subform and the form listing the request records. I hope this helps. I so appreciate your help!