Open form that shows current record

[Leah Trahan]

I am new at Access, databases, AND posting threads (sorry). I have a subform that is a continuous form based on a tabular query. I enter a particular serial # (on the main form) and the subform shows me one to several forms that are related to that serial #. Each form shows only a few select fields of that particular record. I would like to be able to click a Veiw button (which is a cmd button on this subform) to bring up yet another form that would show ALL of the fields of that ONE SAME record. I've gotten as far as being able to get the view button to work when I have just the subform, itself, open. However, when I have the main form open (which then means the subform is also open), and click the View button, I get a dialog box to enter a parameter. Of course, once entered, the form pops up with the correct record referenced. Any help would be a godsend! Thanks! (Oh...Access 2003/XPPro)

[MMcCarthy]

I am new at Access, databases, AND posting threads (sorry). I have a subform that is a continuous form based on a tabular query. I enter a particular serial # (on the main form) and the subform shows me one to several forms that are related to that serial #. Each form shows only a few select fields of that particular record. I would like to be able to click a Veiw button (which is a cmd button on this subform) to bring up yet another form that would show ALL of the fields of that ONE SAME record. I've gotten as far as being able to get the view button to work when I have just the subform, itself, open. However, when I have the main form open (which then means the subform is also open), and click the View button, I get a dialog box to enter a parameter. Of course, once entered, the form pops up with the correct record referenced. Any help would be a godsend! Thanks! (Oh...Access 2003/XPPro)

What code are you using behind the view button?

[NeoPa]

Yes, This will be a query of some form I suspect. Can you post the SQL of the query too if you use a QueryDef (saved query) in your code.
From your post it sounds like your query is using a parameter of some form. We need to replace that with the selection from your form but need the details first to know exactly how to.

[Leah Trahan]

Thanks for your replies, but I figured it out in the meantime! All I had to do was to use the cmd button wizard! Geez! I had created the button, originally, thinking I would have to use some specially created macro, so I had skipped the wizard... It created the following event procedure:

Private Sub cmdView_Click()
On Error GoTo Err_cmdView_Click
 
    Dim stDocName As String
    Dim stLinkCriteria As String
 
    stDocName = "frmViewSerNum"
 
    stLinkCriteria = "[idsNCRNum]=" & Me![idsNCRNum]
    DoCmd.OpenForm stDocName, , , stLinkCriteria
 
Exit_cmdView_Click:
    Exit Sub
 
Err_cmdView_Click:
    MsgBox Err.Description
    Resume Exit_cmdView_Click
 
End Sub

I'll be posting with some other problem soon, I'm sure! Thanks again!

[NeoPa]

That's fine and thanks for replying.
It's actually better when the OP finds the solution themselves. It indicates learning and growth :)