have attached sample:
how can i write update statement-to update Table2 with data from Table1?
The fields in Table2 that are not in Table1 - i want the data to remain in the fields - when it is updated
thank you Database2.accdb
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data.
A Microsoft Access subform is used to show relevant calcul…