I am having a problem with my datagridview reloading. I am working in VB.NET 2008 using Access 2007 as my database. I have two forms each with a datagridview one them. One is for current records and one is for old records. On form load the current date is checked to determine if the record is current, see following code
Private Sub frmShowArchieve_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim dtHoldDate As Date
dtHoldDate = System.DateTime.Today
Dim adapter As New SecurityDataSetTableAdapters.se00t01aTableAdapter
Dim dv As New DataView(adapter.GetOldData)
.RowFilter = "accto < #" & dtHoldDate & "#"
dgvArchieve.DataSource = dv
My problem is that sometimes the user wants to change the accto date to make the record active again. The user changes the date but as soon as the row loses focus the record disappears from the datagridview. Naturally now the record cannot be updated because it is no longer in the datagridview. I have done extensive searching on the internet and have not been able to find the answer to this issue. Can anyone please tell me how to solve this issue.
Thank you in advance for all your help.