[RESOLVED] Data not updating in data report

[weisi]

Im using a data report for report and im getting the fields from an access database. I have created a form which the user can key in details and then it will be stored in the database. But the problem is that the data report is not updated when the details are key in, I would have to close and restart the application then the data then can be read from the report. Whats seems to be the problem? Why isnt the data updating immediately? Pls help! Thanks in advance!

[KGComputers]

Try refreshing the data report...
I also have experienced this problem...

datareport1.refresh

[weisi]

I tried refreshing but still the same. Im using 3 commands in 1 dataenvironment for 3 reports. Does this affect the report? Or should I use 1 dataenvironment and 1 command for 1 report?

[weisi]

Please advice...

[KGComputers]

I tried refreshing but still the same. Im using 3 commands in 1 dataenvironment for 3 reports. Does this affect the report? Or should I use 1 dataenvironment and 1 command for 1 report?

Hi,,,

It does not matter if how many commands are there in your data environment...

By the way, I've come up with a post about this problem...I forgot where it is...I'll try for a search...

[weisi]

Thanks for the reply! Please let me know when you have found the post. Still have no idea about the updating of the database to the datareport.

[KGComputers]

http://www.vbforums.com/showthread.p...sh+data+report

Hi,,

Have a look on this.....

[weisi]

http://www.vbforums.com/showthread.p...sh+data+report

Hi,,

Have a look on this.....

Thanks man!

[KGComputers]

Hi,,,

No problem....Glad to be of service...Which post number did help your problem?
Thanks...

[weisi]

Post #8. I have posted another problem in the same link
http://www.vbforums.com/showthread....esh+data+report <Post #12>
&
http://www.vbforums.com/showthread.php?t=390356 <Post #14>

care to have a look? Thank you!