data is getting updated properly only reopening the application

[Sridhar G]

I am new to VBA and have very minimum knowledge on it. I have a form with data (records) loaded and when you double click any record in the form, one edit form will be opened where you can edit the data. when I change any data from the edit form the data is not getting reflected in the main form. You can view the correct data only if you close and open the application.

But once you change the data in the edit form and click on save button, the data ia getting updated in the backend properly., where as it is not getting updated in the main form unles you close and reopen the application.

Can you please susggest on this.

[hype261]

Basically what you are going to have to do is when you save on the edit form you are going to have to requery the main form.

Psuedo Code

if (isFormLoaded(mainForm.Name)) Then
Forms![mainForm].Requery
End if
 

[NeoPa]

Hype is absolutely right. I just thought I'd try to explain what is going on so you can understand why you are seeing what you are seeing.

When you open the main form you will have the Recordset Type set to either Dynaset, Dynaset (inconsistent) or Snapshot. Whichever type is used the form gets the data when it has to (For Snapshot it gets all the records at once and for the others it gets them as they are required - with some buffering), and doesn't get it again until it is triggered to. Dynaset (Dynamic Dataset) types can have the data refreshed from time to time automatically, but Snaphot types, as the name implies, are retrieved once only. As there is no logical linking between the data being updated in the other (Edit) form, and the data displaying for the main form, it is unusual for the updated data to be reflected unless the main form is told specifically to get its data again. This is done with the .Requery or .Refresh methods. .Refresh reflects changes to the data, but only in pre-existing records, whereas .Requery gets all the data again from scratch.