Thanks alot Eric,

One problem though, it didn't work for two tables. I don't know why. I open one form and gives me an error. I ignore it and open up all my other forms. I then come back to this form that was giving me troubles and it opens with the data that was in there before. Any ideas?

Tyler