I want to update a form with subforms all at once.

  • Thread starter Thread starter Frank Martin
  • Start date Start date
F

Frank Martin

I have Axcess2000 with WindowsXP

I have a main form and two subforms on it.

The subforms update as soon as the cursor leaves them, but I want to leave
the data showing in these subforms until the very end, so alterations can be
made if necessary.

Then by pressing one button I could update everything at once.

Can someone point me in the right direction here?

Regards Frank
 
Sorry, it is not possible as there is the "AutoSave" feature in the Form /
Subform combination. As soon as the Focus moves from the Main Form to a
Subform, the current Record on the Main Form is updated. The same happens
when the Focus moves from a Subform to the Main Form or another Subform.

There are some work-arounds, e.g. using temporary Tables but it requires a
fair bit of VBA code and generally messy.
 
Back
Top