Detail Not Visible Based on CheckBox

[geraldcor]

Detail Not Visible Based on CheckBox -Fixed...ish

Hello All,

I have a one to may relationship where a sample can have multiple free form reports attached to it. These are stored in a table. I have a check box on the form (and the table of course) where the user can check whether or not they want that page printed. The way I am dealing with this is some simple code.

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

If Me.PrintPage = -1 Then
    Me.Detail.Visible = True
Else
    Me.Detail.Visible = False
End If

End Sub

If the first page is checked to print, everything works fine. If the first page is not checked to print then the first page shows up, then the first page that should be printed is not visible then the others following are visible. If only the last page is checked to be printed, only the first page shows up.

If I add a

MsgBox Me.PrintPage

at the beginning of the detail format, I get two numbers for each page; the right one and then the number for the record after that.

Any help on getting this straightened out would be great. Thanks

Greg

--So, I fixed this by using my brain and setting a criteria in the query to just omit the records I didn't want. Sorry for the errant post.

Greg