Staging Form/Table

[DreamGenius]

I'm looking for a bit of clue really. I know what I want to achieve but not the best method of doing so. I'm working on a customer database and they've asked for a method of automatically updating fifty records, chosen by them, through a process, as follows:

1. Identify bank of records, manually
2. Print a sheet of sticky labels using Report
3. Print an invitation using Report
4. Print a Reply To using Report
5. Confirm all print-outs correctly produced
6. Update table flag on each record to say done

My initial thoughts were of a form with fifty textboxes into which the unique identifier could be entered, bound to a staging table, which would then be the basis of the next stages, the table being wiped at the end of the process.

My challenge is in getting the initial bank of records. I thought to use DLookup on the OnUpdate event of the boxes they're entering the unique identifier into, to populate other labels to provide a visual check that they'd entered the person they thought, but it's just too slow. It takes seconds for three textboxes which, when multiplied by 50 ...

There has to be a better way that I don't (yet) know about.

 

[DreamGenius]

Okay, I've solved the problem, but I think it's ugly. I've built a form in datasheet view but the only field the user can entry is the first one, which the unique identifier.

An After_Update event fires some VBA code that runs a query and populates the remaining fields with the details current in the database. The form is bound to a staging table, from which the various printed reports are run.

Once the user has confirmed the successful printing of the various forms, the staging table is cleared down, ready for the next batch.

 

[DCrake]

Why not simply place the names of all the contacts in a multi select listbox. Then let the user select the ones they want by the name of the contact. They are most likely to know their name as apposed to the id. Then use a for each item selected loop to do the necessary. Alot more cleaner and plesent to the eye.

David