Open subform that has the current record of calling form at opening

I though this would be simple but searches have not worked. here is my code from the caling form:

Private Sub BD_stuff_Click()
On Error GoTo Err_BD_stuff_Click
Dim stDocName As String
Dim stLinkCriteria As String
stLinkCriteria = CurrentRecord
stDocName = "RFIsBD_stuff"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_BD_stuff_Click:
Exit Sub
Err_BD_stuff_Click:
MsgBox Err.Description
Resume Exit_BD_stuff_Click
End Sub

I thought defining the "stLinkCriteria" would work but it did not. I've tried severa other things from on line searches but nothing has worked the subform always is opened to the 1st record.

I don't understand the context for this question. Searching this forum, from your hard drive, from an application?

Silvera said:

I though this would be simple but searches have not worked. here is my code from the caling form:

Private Sub BD_stuff_Click()
On Error GoTo Err_BD_stuff_Click
Dim stDocName As String
Dim stLinkCriteria As String
stLinkCriteria = CurrentRecord
stDocName = "RFIsBD_stuff"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_BD_stuff_Click:
Exit Sub
Err_BD_stuff_Click:
MsgBox Err.Description
Resume Exit_BD_stuff_Click
End Sub

I thought defining the "stLinkCriteria" would work but it did not. I've tried severa other things from on line searches but nothing has worked the subform always is opened to the 1st record.

Click to expand...

This is all about ms access isn't it? Line "Resume Exit_BD_stuff_Click" can be removed....totally useless.
It's not a subform at all! It's just a new form you open from a routine (most liekly a button click). The problem is stLinkCriteria. What do you want to accomplish with: stLinkCriteria = CurrentRecord?
CurrentRecord is a property of the form so should be programmed as Me.CurrentRecord. But what do you want to do with current record number?

How do I open one form from another based on 2 criteria in the original form. - dBforums

Read whole thread

You are correct. I posted it on an access forum but did not get a response. Glad you knew what I was talking about. I have since realized that is was not a sub form but a supplemental [yes separate] form, I added new fields to track a new situation so I created this form to manipulate the new data. A friend also a part-time programer for his job we are both architects. He manages the firm and I the construction administration of project being built. He suggested I define stLinkCriteria, I probable misunderstood what he was telling.

Yes I use a label as a button to call the new form. I want it to open at the same record as the one that is calling the new one. I've been self teaching myself data base programing since the mid 80' and do not do it enough to remember all I have learned. I will try it out later this afternoon to see if I can make it work. Thank you very much for responding to me cry for help!!!

What do you mean by saying "same record"? Has the record a primary key? Is recordsource on called form the same as calling form?