Copy Transaction and Send to another table

[jo8701]

Hi Guys,



We currently have about 25 users who log in transactions on a form, some of those transactions need to be double checked by other users before it is complete. Each user has a cue of outstanding work (a table few when they log into their page).

i have created a drop down list of users and next to it is a button with currently no functionality

What i require is - to select a user from the drop down, <click on the button> and the transaction i am working on gets copied and sent into the selected users cue (if that makes sense) - in a different colour (if that is possible)

Can any one help me out with this one?

[pbaldy]

Personally I would not have separate tables. You should be able to accomplish what you're after with a "user" field and perhaps a "status" field. The combination should allow you to have unprocessed transactions in a queue for your users.

If you want to move them around anyway, you'd use an append query (and a delete query if you want it out of the current table), using a reference to the form in the criteria to identify the record.