Print Multiple Records from a Continuous Form

[mike60smart]

Hi



I have searched for an example of how to Print Multiple Records from a Continuous Form with a Criteria that a Yes/No Checkbox is set as True.

The only example I can fine is using a Listbox.

Can this be done directly from a Continuous Form?

Any help appreciated.

[June7]

Forms can be printed but reports are better vehicle for printing.

The yes/no checkbox is bound to field? Apply filter to form.

[mike60smart]

Hi June

My apologies.

Put this down to my age but I have now solved my problem.

I had forgotten to specify the criteria and this now works just great:-

Private Sub cmdLoadSheet_Click()

10        On Error GoTo cmdLoadSheet_Click_Error
       
       
20    If Me.Dirty Then Me.Dirty = False


30    DoCmd.OpenReport "rpt_JobLoadSheet", acPreview, , "[Selected] = True"




          
40        On Error GoTo 0
50        Exit Sub


cmdLoadSheet_Click_Error:


60        MsgBox "Error " & Err.Number & " (" & Err.Description & ") in procedure cmdLoadSheet_Click, line " & Erl & "."


End Sub