How do I synchronize records between two forms in Access ’03 using Expression Builder?
In other words, If I’m viewing record “345″ in my first form, how can I make a macro to view record “345″ on my second form?
Put a Command button on the design area of your first form which opens the same record on your second form. You don’t need a macro, the command button wizard will take you through the process.
During the process you choose a specific record on your second form, based on the data in your first form. In your case this will be the record number of the underlying table.
Felix Baumgartner’s supersonic freefall from 128k’ – Mission Highlights