In my application i use adodc to connect with access database and have command button to show a report consisting of datas from that database. I also have command button to add datas in runtime. But in runtime when i call for show report firsttime it show what is in the respective database table, but after adding any new data it shows the previous report without updating it. It seems like report is not refreshing. What should i do to get the latest report everytime? Please help me...... I cant find a way....
shahriar2403
0
Light Poster
Recommended Answers
Jump to Postyou can make a trick on this.
just unload the form and show it again.
likeunload frmAdd
frmadd.showthen fire the code inside the button responsible for displaying the report.
All 3 Replies
choudhuryshouvi
33
Posting Pro
you can make a trick on this.
just unload the form and show it again.
like
unload frmAdd
frmadd.show
then fire the code inside the button responsible for displaying the report.
debasisdas
580
Posting Genius
Featured Poster
You can try to refresh the recordset.
shahriar2403
0
Light Poster
I have tried to make the recordset keep updating by using code rsname.update. But I am not clear about the recordset refreshing.... give some example. And i also tried unload the form. But it does not seems to work. I would be very greatful if you guies provide any attachment example projects relevent to my problem. Please anybody help meee.......
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.