1,105,380 Community Members

Vb form refreshing

Member Avatar
ashwinshenoy
Newbie Poster
18 posts since Apr 2011
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
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

Member Avatar
Matthew N.
Junior Poster
101 posts since Jul 2010
Reputation Points: 0 [?]
Q&As Helped to Solve: 10 [?]
Skill Endorsements: 0 [?]
 
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

Member Avatar
ashwinshenoy
Newbie Poster
18 posts since Apr 2011
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
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

Member Avatar
dxider
Light Poster
33 posts since Mar 2011
Reputation Points: 0 [?]
Q&As Helped to Solve: 5 [?]
Skill Endorsements: 0 [?]
 
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 three months: Start a new discussion instead
Post:
Start New Discussion
View similar articles that have also been tagged: