We would then need to execute both queries, one at a time, to complete the task of updating the master table.But, since the challenge was to perform both the update and append actions in one query, we had to use a different technique.
Then check each control to ensure it is linked to the field where you want to save it to in the table.
For instance; if you are using as your table, then it should be visible in the Record Source. Chances are good because this once worked, that the form fields will relink themselves.
If this isn't enough info, please let me know what you need. By doing so allows for the controls (textbox, combobox, etc) to be linked to the fields in the table.
Check the form properties to ensure the table you are saving data to is the source.
We then create one query that joins the master table to the linked table.
However, in this case, we will use an OUTER JOIN to return all the records from the linked table.As a result, the database engine will update existing data and append new records at the same time.You must enforce the Referential Integrity rules first then you can put a checkmark in Cascade Update Related Fields. This is just a way to save you time and effort in keeping your data accurate.The first step, usually, is to link to the Excel spreadsheet so we can access the data from within Access.We can then create an UPDATE query that joins the master table with the linked table to apply the latest changes to the data.See for yourself by just opening the related table! To hear about the latest Office 2010 news, blogs, and training, subscribe to our newsletter. If you want to learn more, check out some of our Microsoft Access 2010 training classes!