Vanishing data

[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. 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 that may vanish!

Thanks in advance

 

[Tom Ellison]

Dear Syd:

If you were to create the relationships between these tables, then the
database will prevent you from deleting rows from the foreign tables
(the ones driving your combo boxes) whenever the value is in use.
This would change the situation so that the person/program that is
performing the deletions now would get an error message instead. That
would then point out how and when the deletions is occurring, and you
could procede from there.

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. 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 that may vanish!

Thanks in advance

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts