newbie question

[hannuk]

Hi, I'm really a newbie using access, so can someone solve this to me:
I want a button, that prints the current subform record.

I've managed to get it the button print a subform, but it prints everything
(the table that I'm using is using foreign key)



I made the button by going to design, and choosing button. I don't know how to script in access

[alansidman]

Here is some VBA that I use to print the record that is open in a form.

Private Sub Command28_Click()
On Error GoTo Err_Command28_Click

    Dim stDocName As String

    stDocName = "Submission"
    'DoCmd.OpenReport stDocName, acNormal, , "[ID] = Forms!frmClients!ID"
    DoCmd.OpenReport stDocName, acViewPreview, , "[ID]=Forms!frmClients!ID"

Exit_Command28_Click:
    Exit Sub

Err_Command28_Click:
    MsgBox Err.Description
    Resume Exit_Command28_Click
    
End Sub

Be sure to change the names of your fields, forms and reports to match what is in your db.

My record ID is ID. The form is named frmClients and the Report is named submission. Put this in the onclick event for the command button.