R
rmanchu
hi
got a form with multiple comboboxes, all backed by recordsets created
from data from a mssql server.
i don't have a particular method/order for loading the comboboxes, then
form or reverse. likewise for unloading
on form_open, a few times i had errors which seemed to go away when i
changed the order of loading, but mostly, i get lots of errors when i
try to close all the recordsets (comboboxes and form), so i don't close
the recordsets for the comboboxes. i'm afraid, i'm wasting a lot of
memory.
so, is there a recommended order when loading up controls/form with
recordsets and then unloading them (which wil make these errors go
away)?
also, sometimes, the forms RecordSource retains the SQL that generated
the recordset. this, of course, generates an error on the next form
open - ie, i have to manually clear the RecordSource property in design
mode.
help here?
thanx
riyaz
got a form with multiple comboboxes, all backed by recordsets created
from data from a mssql server.
i don't have a particular method/order for loading the comboboxes, then
form or reverse. likewise for unloading
on form_open, a few times i had errors which seemed to go away when i
changed the order of loading, but mostly, i get lots of errors when i
try to close all the recordsets (comboboxes and form), so i don't close
the recordsets for the comboboxes. i'm afraid, i'm wasting a lot of
memory.
so, is there a recommended order when loading up controls/form with
recordsets and then unloading them (which wil make these errors go
away)?
also, sometimes, the forms RecordSource retains the SQL that generated
the recordset. this, of course, generates an error on the next form
open - ie, i have to manually clear the RecordSource property in design
mode.
help here?
thanx
riyaz