Access is deleting data

[Guest]

I have a database where the data in one of the fields in one table keeps
vanishing. Every time I re-open the database, that field is empty,
regardless of what data I had entered the last time I had the database open.
Does anyone have any idea why this would happen?

 

[Joseph Meehan]

I have a database where the data in one of the fields in one table
keeps vanishing. Every time I re-open the database, that field is
empty, regardless of what data I had entered the last time I had the
database open. Does anyone have any idea why this would happen?

How about telling us all about that field. Type primary key?
relationships etc.

 

[John Vinson]

I have a database where the data in one of the fields in one table keeps
vanishing. Every time I re-open the database, that field is empty,
regardless of what data I had entered the last time I had the database open.
Does anyone have any idea why this would happen?

If it's disappearing from a Form, perhaps it is an unbound textbox
(rather than being stored in a table), or perhaps the Form is based on
a Query and the query is such that the field is not being stored (or
not being displayed after it's stored).

More details please! What's the datatype of the field? Does it
disappear if you enter it in table datasheet view, or only using a
form or query? If a query, what's the SQL of the query?

John W. Vinson[MVP]