Re: "no current record"

  • Thread starter Thread starter James Brown
  • Start date Start date
J

James Brown

Hi,

"no current record" usually means exactly what it says - that the record you
are currently trying to access does not exist. Are you sure the data for
the report has not been deleted / changed in between you opening the first
page of the report and moving to the next?

Jamie.
 
I have a similar problem.
I have a database that works perfectly fine in Access 2000 and Access 2003. When it is converted to 2007 however, I get the same issue with a certain report. The report is dynamically setting the control source for a bunch of different fields on the On_Load event of the report.
The first page shows up fine, but when you click the arrow to proceed to the second page...I get the "No current Record" error.
However, if I select "Report View" instead of "Print Preview" for the report...it will display all the results correctly. So something Access 2007 does with it's paging seems to be screwing up the report.

Any thoughts?
 
Found out my problem!

Access 2007 has a bug-- If you programmatically set the control source, then it will either throw the "No current record" error or it will simply crash the database.
As a temporary work around until Micorosoft fixes the problem, I do an export to an rtf. Report view works (because it has no paging) but print preview does not.

Hope this helps!
 
Back
Top