RecordSet

[Guest]

Hi,

I have a form that requently updates the data from user inputs. However,
every update it opens the recordset, updates the data then closes the
recordset. I wonder if I could open a recordset globally so that every
update would not require the form to reopen the recordset again? Please let
me know if this is doable and how. If you have better ways of doing it,
please share it. thanks.

 

[Dirk Goldgar]

Hi,

I have a form that requently updates the data from user inputs.
However, every update it opens the recordset, updates the data then
closes the recordset. I wonder if I could open a recordset globally
so that every update would not require the form to reopen the
recordset again? Please let me know if this is doable and how. If
you have better ways of doing it, please share it. thanks.

Is there a reason you aren't just using a bound form?

 

[Guest]

yes,
a bounded form is used to store the user inputs. the system needs to
calculate other numbers and store them into different tables. the
calculations are too complex for queries. it must be done through VBA in an
array. the result is then written to tables using recordset.

 

[Dirk Goldgar]

yes,
a bounded form is used to store the user inputs. the system needs to
calculate other numbers and store them into different tables. the
calculations are too complex for queries. it must be done through
VBA in an array. the result is then written to tables using
recordset.

If you really need to do this, you could define a module-level recordset
object, open it in the form's Open event, and close it in the form's
Unload event.