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
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