table loosing data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jburbridge@hes-inc.org - 31 Dec 2003 16:41 GMT

Access 97 user, has a health database. Can enter info in
a form or on the table. One of the fields is a status
field on the form and database. The inactive children are
changed from e status to l status, however they are
disappearing from data base.

help

Reply to this Message

John Vinson - 31 Dec 2003 18:21 GMT

>Access 97 user, has a health database. Can enter info in
>a form or on the table. One of the fields is a status
>field on the form and database. The inactive children are
>changed from e status to l status, however they are
>disappearing from data base.

I strongly suspect that they are disappearing *from view on the Form*,
because the Form is designed based on a query to show only active
status children. If you open the underlying table, I would expect that
the data still exists - you're just not seeing it. Is this the case?

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

Reply to this Message