I have two forms that access the same database, the second form adds new records to the table while the first form reads from it.
When I add a new record in the second form and I press OK, I am returned to the first form, my problem is that the first form does not show the newly added record, I have to close the entire program and re-load it in order to see the changes.
I'm wondering if there's a way once I add a new record to update the bindingsource in the first form to reflect the new changes.
the following is the code I use in the first form to read from the table
Dim prjData As ClientsAccess
Dim prjDataset As nclMisDataSet
Dim WithEvents prjBindingSource As BindingSource
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
prjData = New ClientsAccess
prjDataset = prjData.getPrjAccessDataSet
prjBindingSource = New BindingSource
.DataSource = prjDataset
.DataMember = "projets"