Search results

Hi Rich If you use the NoData event in the subReport,(cancel=-1)that will not close the main Report. I tried adding:- DoCmd.Close acReport,"MainReportName",, to the NoData event of the subReport but that doesn't work. Any ideas? Thanks [This message has been edited by AlanW (edited 02-06-2002).]

I have a main report that has a subReport. The main Report has no recordsource. (The subReport does) How can I close the whole Report if the SubReport has no data. Any assistance appreciated

I trying to do something like this:- On Activate Me.Refresh End Sub

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

I have a Field that contains both numbers and text. I would like to filter out just the numbers. What do I need to put in the criteria of the query? Thanks