Hi Eric,
The LockType is set to adLock Optimistic. It was defaulted at that so what should I change it to?
The Addnew works on the first form for the first table but doesn't give a blank record for the second table. The fields are blank but when I try to save the information in the text boxes it desn't save.

Thanks again!
Max
>Are you able to use AddNew on your first form? Have you changed the LockType to something else then ReadOnly? Try the AddNew without the JOIN (only on 1 table).