Need some assistance with VB and Data Reports. I have a project connecting to a Access MDB file. I am using the built-in VB Data Environment and Data Reports. My project opens the reports using the syntax: drReport.Show or drReport.Print. The first time the reports run, they grab data from the MDB using Select statements against a table which is populated on the fly with InsertInto statements. Each subsequent time the report is run, it displays data from the first instance - instead of the newly specified record. I have tried adding code in the Initialize() event of each report that calls the recordset.Refresh method - with no success.
Has anyone run into this, and if so, is there a work-around?
Much thanks to anyone who can help.
Todd
Todd Tebay - MCSE, MCP+I