Choose a Table

[SueBK]

I've probably gone about this the wrong way; but ...

I've got a database that tracks our project budget and our invoiced hours to date. Each invoice covers a bracket of weeks and we are now getting variations against those weeks. To ensure that I can replicate each invoice exactly as it was issued before the variations were made, I've been asked to 'post' each invoice as a table once we've submitted it.

I now have tables "invoice01", "invoice02" etc. Now comes the "if I get hit by bus" complication If someone uses my current form for *generating* invoices they get a query based on the current data (not the posted data). I need to create a selection dialogue box/combo box/similar etc that will allow users to select the correct table for posted invoices.

 

[HiTechCoach]

I've probably gone about this the wrong way; but ...

I've got a database that tracks our project budget and our invoiced hours to date. Each invoice covers a bracket of weeks and we are now getting variations against those weeks. To ensure that I can replicate each invoice exactly as it was issued before the variations were made, I've been asked to 'post' each invoice as a table once we've submitted it.

I now have tables "invoice01", "invoice02" etc. Now comes the "if I get hit by bus" complication If someone uses my current form for *generating* invoices they get a query based on the current data (not the posted data). I need to create a selection dialogue box/combo box/similar etc that will allow users to select the correct table for posted invoices.

While I could show you how to do what you are asking for, I feel that I woudl just be leading down a part of misery, headaches, and unhappy users.

"Posting" does not have to mean copy to a new table. I always keep all my invoices in a single table. I think what you want to do by "posting" is to really just lock the records so that they can not longer be edited/changed. This can be handled in a single table a lot easier that the way you are trying.

I used a field for "posted date". If there is a date in the field, then the record is locked. I place a VBA code in the form's On Current event to handle this.

Curious, Is your database split? (My guess would be no. )