I have one main form which contain three subforms overflapping each
other. Depending on a data field (X) on the main form,
when X=1 then subform1.visible =TRUE while the others FALSE;
when X=2 then only subform2.visible =TRUE; and
when X=3 then only subform3.visible =TRUE.

Each subform has its own set of data to update. I could managed to
update one of the subforms, the other subforms could not be updated;
they simply just revert back those edited data.

Example, when X=1 subform1 could be updated and then I switch X to 2,
and subform2 appear (and data for subform1 were nicely updated). I
could edit its data, however when I switch X to 3, all those edited
data on subform2 was completely reverted. Any idea what went wrong ?
Or how do I force data update from subform2 ?

Thanks
sean

Sean,

As the subforms are overlapping, you may be entering data into the wrong
form. You should set .Enabled = False when you set .Visible = False for
each form you don't want to see.

Hope this helps,

Gary


"sean" <sean (AT) kistem (DOT) po.my> wrote

Thanks Gary,

I always thought that .visible=false will assume .enabled =false too.
sean.


"Gary Floam" <floam (AT) comcast (DOT) net> wrote