Combo Box Text Vanishes

  • Thread starter Thread starter Syd
  • Start date Start date
S

Syd

I have this application. Each data input interface
contains at least two drop down combo boxes with numeric
values for plugging into record being created.

However, data records from two of the tables behind the
Drop down combo boxes disappear mysteriously. It seems to
be the same records every time it happens. The application
is running in a multi-user environment and is Access 97. I
do a me.requery in the "AfterUpdate" event of both combo
boxes plus check the previous controls for data values
prior to allowing additional data entry.

Since, I also have previous Drop Down's plugging in values
to filter to resulting returned data for the next control
in the tab order on things. I also do a me.requery in
the "GotFocus" event of the two combo boxes to force a
filtering of the returning data a second before the drop
down is clicked.

Any ideas on solving this mystery of disappearing data
will be appreciated. To overcome the data loss I've
created a backup (should not be needed) copy of the two
data tables driving the combo boxes so that I can rebuild
the data after it disappears from the working tables,
whenever it may vanish!

Thanks in advance
 
Jonahtan:

I'm sorry, but the form being used is a single, not a
continuous form. I'd understand it, if it were a
continuous form. But it's not. Something else is going on
with the combo boxes.

Thanks, for the first stab at it.
 
Are the data actually "gone" from the table? or just not displaying in the
dropdown list? or just not displaying in the combo box?
 
Back
Top