print records from listbox

B

BrianPaul

I have on a form have a list box, I have a command button with the following
code.

Private Sub Command99_Click()
On Error GoTo Err_Command99_Click
Dim stDocName As String
Me.Visible = False
stDocName = "RSeed and Promises"
DoCmd.OpenReport stDocName, acPreview, , "[scriptureid] = " & [List93]

I changed it to a multiselect list box (simple) Thinking that I could
filter those records I wanted to print. I get an error. It works printing
one record. This tells me I am missing something. Any help would be greatly
appreciated, Using Access 2003. Thanks.


Exit_Command99_Click:
Exit Sub

Err_Command99_Click:
MsgBox Err.Description
Resume Exit_Command99_Click
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top