>I have a form A.
>When the user clic a button, I want to close form A and open form B.
>But I want to make sure the data environment of form A is closed (and flushed) BEFORE opening form B,
>
>Where should I put this code ? After the thisform.release ? somewhere else ?
>
>Thks
>Eric
I had the situation where the data in FormB is dependent on FormB: FormB is a child of FormA, with respect to the tables involved; i.e., if a new parent record is not saved, then the user would get error messages (trigger failed) when trying to save the child record.
In this case, I simply try to make sure that the parent table is saved. While there are pending changes, the user is not allowed to open the child record.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
