Endojoe
Registered User.
- Local time
- Today, 00:15
- Joined
- Apr 7, 2009
- Messages
- 20
I have two tables, 'table1' has around 4500 records but is no longer being added to because I have created 'table2' to take it's place due to the fact that I couldn't set a couple fields in 'table1' to be indexed with no duplicates (over the years many duplicates had already been carelessly entered, and it would take too long to fix them all).
Unfortunately, I need to be able to go back and look through the records in table1 from time to time. table1 and table2 are identical (except for the aformentioned couple of fields that now will not allow duplicates). I was thinking an Option Group or Toggle Button would be great to switch the 'form1' record source between the two tables, but for the life of me, in all my searching, here and with Google, I have been unable to find a way to accomplish this.
Thank you all in advance,
-Will-
Unfortunately, I need to be able to go back and look through the records in table1 from time to time. table1 and table2 are identical (except for the aformentioned couple of fields that now will not allow duplicates). I was thinking an Option Group or Toggle Button would be great to switch the 'form1' record source between the two tables, but for the life of me, in all my searching, here and with Google, I have been unable to find a way to accomplish this.
Thank you all in advance,
-Will-