Greetings. The title doesn't give the full info - here's the rest. The db I created for my Boss gives her the option to create what basically equates to a back-up of a table. I'm currently giving this backup table the name "tblPrior_ yyyymmdd" with yyyymmdd equaling Format(Date, "yyyymmdd"). I have several of these tables which have different run dates inside the table (fieldname is Prun_Dte).
So what I'd like to do is to pull the Prun_Dte value and put it in a temp table (permanent table?) and then run a query against those values that will populate a combobox that will allow my Boss to select which table she would like to restore.
I don't mind changing the way I'm currently naming "tblPrior_yyyymmdd" if doing so makes it easier to accomplish what I'm after.
I hope I've made this clear (and I'm sure I'll be notified if I haven't ).