Deleting records from a query

[banpreet]

Hey guys,



I have an approval queue button on my main menu that opens up a form for records for approvers that have to approve the form. Each person will have different numbers of forms to approve. How do I delete the record off the form after they approve it.

I have another queue for approvers to approve something else on a form, this can be sent to multiple people. So lets says approver 1 opens up his queue and has to approve a form, approver 2 can open up his queue and have the same form to approve. How do I make that after the first person approves it, it removes it from all their queues for that specific record.

Thanks!

[orange]

Populate your form with unapproved records only.
When a record is approved, requery the form.
Only unapproved records will appear.

You need some indicator for records that were approved, and now must have some other attribute reviewed.