1.11M Members

Vb form refreshing

 
0
 

Hi All,

I am trying to update my form once the delete button is clicked. There are several fields like Name, Date, Date of Birth and so on. Once I delete a record I want the form to automatically load with new / updated data. This form fetches data from MS Access using OLEDB
I have spent a long long time trying this but did not get any solution.
Please help

Regards,
Ashwin

 
0
 

You can refresh a form be using Me.Refresh , so you could get your data in variables such as :

TextBox1.Text = Name
TextBox2.Text = Date

etc, getting the variables from the database.
Watch Youtube Video On Connecting To Access Database (This is a 2 part video)
After loading data, call Me.Refresh() Watch Part 2

 
0
 

Hi Matthew,
Thank you so much for the reply. But this does not solve my problem. I have tried ME. Refresh() earlier as well.
Once i delete the data from the Db and when i call the function to display the form, the form wont update with the new values but shows the same values but when I click click the delete button again and when the form loads this time it will be updated.
I cannot understand why it is updating during the second instance but not during the first.


Thank you so much
Ashwin

 
0
 

Please provide your code. Refresh method only redraws the user interface, but don't fetch new data from you database. If you provide your code, we can have a better idea of what you want to do.

You
This article has been dead for over six months: Start a new discussion instead
Post:
Start New Discussion
View similar articles that have also been tagged: