I read a recent post which I thought might address my current problem but it seemed that problem was much more complicated than my own. With that...
I have a database with 6 tables. There are 649 records in each table with different information regarding each client. The tables are all linked, data on each being updated by a form that was designed through a query selecting fields from the respective tables.
At the moment, when I open the form to add a new client, it does show that there are 649 records currently existing. I go to "New (blank) record" to create a new record and enter in all of the information for the new client (number 650). The form template does indicate that this new form is now "650 of 650." I hit save and exit the form. When I reopen the form, this new record is nowhere to be found. Only the previous 649 are present. At the same time, all of the tables the form is supposed to update do have all of the new information I entered.
Can't figure out why the form doesn't keep the new data I entered when all of the tables relying on the form do! Thanks.