I have a record that keeps showing up in the form even after I have deleted it from the table. I can over right it but it comes back on the next opening of the form.

The odd thing is that the table is completely empty. Where else could the data come from? This just started a week ago, the only thing that we did different last week from previous weeks is that there were multiple people entering records at the same time. Access asked one of the people entering records if they wanted to save their newer version of the form (not sure why it asked that) and the person selected yes. It could be a coincident but the record that is stuck on my form comes from that user!

Any ideas?

Check the RecordSource of the Form. Either it is pointing to a different Table or Query or you are looking at the Wrong Table when you see no Records. It can't be that the records are coming from nowhere.
Chris

I know what you are saying but it is there. The control source is pointing at the right table and the table is empty. What is even stranger is that I have the form to open up ready for a new record so that the user can not flip through previously entered records.

Is it possible that you have a "default value" set?

yeatmanj,

Give me a great big doooooooohhhhhhh! There were default values set. I have no idea how they could of got there.

I do have those fields filled with the default value of the last entered record when the users exits the last filed of the form. Maybe when this particular user chose to save when they closed the database (see first post) Access chose to set those as the default values permantly.

[This message has been edited by Talismanic (edited 10-20-2000).]

Not sure if you were being sarcastic or not. But either way, I'm glad I could be of help. lol

Only sarcasm about me not checking for default values before coming here (the forum) first. It is just so weired that it happened at all I never would of thunk it!

Thanks again you saved me a lot of moaning and nashing of teeth http://www.access-programmers.co.uk/ubb/smile.gif