Shryer

OK, while I have been writing VB code for a while I am still fairly newbie at integrating with databases. Because of this i'm having a problem that I hope you gurus can solve.

I am trying to setup a Data Report to do some custom printing and am having some problems.

Background info:
I have the data report linked to a table in an Access 2k (Jet 4.0) database that contains only 2 records (1 blank and the other containing the data to print). What my program does is populates the table with the data to be printed then it shows the Data Report.

Originally when I tried to display the Report all I got was a blank screen. I fixed this by closing the recordset and re-opening it as Client/Static/ReadOnly (for writing the rs is open as Client/Dynamic/Optimistic). At which point I got the data currently saved in the table to display.

The Problem:
For some reason now, any changes made to the recordset are lost when I close and re-open the recordset.

So far I have tried moving to a different record in the table (thus the need for 2 records), using a BeginTrans/CommitTrans pair, and using rs.Update but none of them seem to work.

Shurik12

Hi,

It would be nice to see the code where you are tring to update the underlying table.
Without this it's kind of difficult to guess what's going on.

Shurik.

Shryer

Actually I stumbled upon the solution shortly after posting this.

Originally I was copying data into databound controls as a method of inserting the data. I tried copying the data directly (using rs.forms("name") ) and it just started working.

Looks like another reason not to use databound controls.

Thanks for the reply though. It's nice to know there are folks out there who care enough to help