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
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.