I am looking for simple vba code to:
1. save all data on all objects on frmOne to Table1
2. Close frmOne
3. Open frmTwo
4. Refresh data on formTwo
This to be put on the click event of Command1 and Command2.
Code that I can easily modify and use on other forms/Cmmand buttons.
Sample db is attached to work with.