C
Chris
I have a access 97 report that is called from a VB 5 application using
docmd.openreport call.
When I open the report this way I get an error 2427 "this expression contains
no data" on the textboxes in the detail section of report. There is data in
the tables it is querying and the SQL query does return records.
If I run the report straight from access it works fine.
I've been trying to fix this for a while now. My idea is to refresh or
requery the report. I have refreshed and requeried sub forms before but not a
report.
intellisence does not seem to accomodate refresh or requery of a report.
I have tried in the report_open event to restate the recordsource this does
not solve the 2427 error.
does anyone know how to refresh or requery a report immediately after the
report is opened?
thanks
Chris
docmd.openreport call.
When I open the report this way I get an error 2427 "this expression contains
no data" on the textboxes in the detail section of report. There is data in
the tables it is querying and the SQL query does return records.
If I run the report straight from access it works fine.
I've been trying to fix this for a while now. My idea is to refresh or
requery the report. I have refreshed and requeried sub forms before but not a
report.
intellisence does not seem to accomodate refresh or requery of a report.
I have tried in the report_open event to restate the recordsource this does
not solve the 2427 error.
does anyone know how to refresh or requery a report immediately after the
report is opened?
thanks
Chris