I have form which displays data held in a table. (nothing radical there then!)
I export the contents of the table each month and have a dataset/table for each month.
I'd like to load an archive version of the form and THEN select which dataset (table) to open. All the data table structures are the same, so once selected, the form acts the same for each archive file.
I thought that I might be able to have a button on the archive form labelled "Select Archive" and when clicked, it allows me to select the archive table which I want to load as the record source.
I suspect that this isn't good practice, but not sure which way to approach the task in hand. Perhaps I should simply export the monthly records into one "archive" table and use filtering
Any suggestion how to achieve this or enlighten me to best practice?
Many Thanks
=Jimbo=