unrelated form/subform msacc. form to update when sub data done - TechRepublic
Question
October 3, 2007 at 04:59 AM
duberyr

unrelated form/subform msacc. form to update when sub data done

by duberyr . Updated 17 years, 7 months ago

Hi

I have 2 transaction files – 1 for creditors, 1 for gl. for every creditor transtion entered on the main form, there may be 1 or more detail transactions on the gl sub form.

I do not want the crs form to update table until gl subform data has been input.

I have a command save button on main crs form that I want to use when both forms are complete.

Trouble is that as soon as focus goes to subform, crs record writes into table. if user wants to cancel form (another button on main form) the crs form has already updated and dirty is no longer set so undo does not work.

Apart from trying to use a number of flags to figure out what is happening is there any way to stop main form updating until save button is pressed?

I do not use navigation buttons.

This discussion is locked

All Comments