Refreshing Report

[AlanW]

How can I get my report to refresh when it is reactivated? I have tried all different ways but Access always comes up with an error?
Any help would be appreciated
Thanks

 

[Rich]

What do you mean "Reactivated"?

 

[AlanW]

I trying to do something like this:-

On Activate

Me.Refresh

End Sub

 

[boblarson]

Have you tried selecting one of your controls (example textbox) and using .Requery?

example:

Private Sub Report_Activate()
txtName.Requery
End Sub

I haven't tested it thoroughly to make sure it will work, but I think it might.

Bob Larson
hth