Requery combo box in subform OnCurrent causes corruption

  • Thread starter Thread starter Yvonne
  • Start date Start date
Y

Yvonne

I have a form with many subforms on it, as well as
subforms within subforms. There are many parameterized
combo boxes that have to be refreshed, and I am finding
that requerying a combo box in the OnCurrent event of a
subform causes the database to become corrupt when the
database is being used by multiple users. Comments?
 
-----Original Message-----
I have a form with many subforms on it, as well as
subforms within subforms. There are many parameterized
combo boxes that have to be refreshed, and I am finding
that requerying a combo box in the OnCurrent event of a
subform causes the database to become corrupt when the
database is being used by multiple users. Comments?
.
Click to expand...
Hi Yonne,
do you have the database split into front and back ends,
with each user having an independant copy of the front end?

Jonathan
 
Hi, Thanks for your reply. I used to but now I don't
anymore. The performance of the application was
unbearable with the data in a separate file. It runs like
lightening with everyone using the same mdb on the
network. Do you think I am getting these constant
corruptions because of locking problems?
Yvonne
 
Back
Top