isaphrael, You cannot refer to a control and get its value when the form is
closed. You can open it via code in design view, but there aren't values
associated with your bound controls until you actually open the form.
If/when you close a form and reopen it, it will requery the underlying data.
It doesn't sound to me like you are actually closing the first form and
reopening it. You need to either requery/refresh the data on your form to
see the results caused by processes that may have changed the data of the
original recordsource. If you could provide more info as to exactly what
you are doing and what you expect to happen maybe I/we can guide you in the
right direction.
--
Reggie
----------
"isaphrael" <id******@yahoo.com> wrote in message
news:54**************************@posting.google.c om...
You can refer to a control on a closed form, such as by grabbing the
value of the tab control from a closed form, but i am not sure what
this does to the form. Does it activate it but not open it?
More to the point, that means that for some forms, values are not
'reset' to nothing when the form is closed. how would this be done?
I'm coming across a situation where i am programmatically closing a
form, and then it is reopened but the old values still exist for the
form. It is a bound form, and the underlying query is changing, but
the values are not being changed.