Note that [Customer Orders Subform1] refers to the name of the subform Control, not the name of the form that the control is based on.

It is also possible (and sometimes preferable) to handle the synchronization programmatically instead of relying on Access to do it for you. This gives you added flexibility when manipulating the subform's behavior. As an example, modify the Customer Orders form (shown above) to synchronize programmatically.

As you've learned, there was no need to write any VBA code to make this operation functional. So, do not always look to VBA code to solve the problem first. Keep in mind that within Access, there are many ways to solve problems—be sure to explore all options before making a final decision.

0 0

Post a comment