Run time error 13 with.visible when add record?

[hansdebadde]

I am hiding a couple pages of my report based on the answer on a checkbox BeyondDOI. I put this expression in the On Current and AfterUpdate().

Private Sub Form_Current()
Me!Page281.Visible = Me!BeyondDOI
Me!Page373.Visible = Me!BeyondDOI
End Sub

Private Sub tbl_F7A_EEsOffBeyondDOI_AfterUpdate()
Me!Page281.Visible = Me!BeyondDOI
Me!Page373.Visible = Me!BeyondDOI
End Sub

It hides and updates when I make changes to a given record, but when I try to create a new reocrd it freaks, and I get the error 13.

I am using Access 2003

 

[dhookom]

This is a report's forum. Shouldn't you close up this thread and ask your question in the Forms forum?

Is it possible for BeyondDOI to be Null? You might want to use Nz(Me!BeyondDOI,0)

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[GingerR]

duplicate post thread702-1096937

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244