I have a form that works off of a query that has a few tables. Everything updates just fine except for one table of the query. It will loose the data I put in when I go back to the entry but if I then put in the data at this point it does transfer the data to the query and table. Any ideas why this would happen?
The relationship is a one to one that joins a few tables together using a main table.
Thank you for the help.
UPDATE:
I updated the query and it worked there so something must me wrong with my form, at least I am leaning that way now.