Print a report from a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I set up a report to print from a form and used this (which I got from this
forym) to get it done,

Private Sub Command164_Click()
Dim strDocname As String
Dim strWhere As String
strDocname = "Centres"
strWhere = "[CentreNo]=" & Me!CentreNo
DoCmd.OpenReport strDocname, acPreview, , strWhere
End Sub

It works, but my question today is, where I have one delegate going to a
specific meeting, this form will confirm his place, but where there are more
than one - up to three - this form wil only print the first delegates'
details. How can I set it up to print a separate one for each delegate?

The form itself specifies the names of all three delegates but it's
addressed to the first delegate only. In other words, I would like to print
two or three letters if there are two or three delegates.

Hope this makes sense
 
I think you need to give a bit more details on your relevant Table
Structure, the set-up of the Form you mentioned and the SQL String (or SQL
String of the Query) being used as the RecordSource for the Report.
 
Back
Top