2 Questions

[generically]

I was hoping that someone will be able to help with this one. I have 2 questions actually.

1) I have the below macro to print out a query from a form. But what I need to do is have it print out the first one. I have it set up to display the hightest numbered one.

Private Sub print_Click()
On Error GoTo Err_print_Click

Dim stDocName As String

stDocName = "list Query"
DoCmd.OpenReport stDocName, acNormal

Exit_print_Click:
Exit Sub

Err_print_Click:
MsgBox Err.Description
Resume Exit_print_Click

End Sub


2) In the same form I have a sub form that is continuos. When I go to print the form I get each line of the sub form on a different sheet

Thanks for the help

 

[Tanis]

How are you determining the first one? Would it not be simpler to pick the record to print? When you say each line, do you mean each record?