I recently added a timestamp field into a simple table. Now when I insert a record directly in the table I'm getting the following message:

"The data was added to the database but the data won't be displayed in the form because it doesn't satisfy the criteria in the underlying record source"

and the new record disappears. If I then close the table and reopen it, the record reappears just how I entered it.

The timestamp field is not displaying any data and it is a primary key field in the table along with another field.

Does anyone have any ideas what might be happening?

Thanks for your help

I would use an autonumber field as the primary key and remove the index from the timestamp field. I cannot think of a reason to have a compound key in this situation.

The autonumber field works much better, thanks!

Yeah, you're right, I guess I don't need multiple keys.....

You are welcome and good luck with your project....

Jack