Calling update form to update two tables?

[Rick_UpperPark]

Hi Graeme,

I wrote up an article here to describe how I update a “sister” table on an update form. This might help you with what you’re trying to accomplish.

How to update more than one table in an update form

Here is a method to use if you have an update form on a particular table and you want to be able to have fields from another related table. This works one there is a one-to-one relationship between the two tables. I’ll call the second table a “sister” table in this example. The key is to use a FieldPairsClass to determine if changes have been made to the sister table at the correct points in the update form. The two things you need to catch is when the user saves the form and when the user ca…

HTH,
Rick