Opening a document

Dear All,

I have an approval database where I want to do the following.

I have a view which displays all the documents awaiting my approval. I can open each document by double clicking on it and than click the approve button on the form. I want that once I open one document and approve it, it should automatically open the next document awaiting my approval, so that I can approve it. Something similar to like when we delete one opened document it will open the next document, similar to mailbox.

I tried thinking a solution for it but was not able to crack a solution for it. I would appreciate to any probable solution which would lead me to the correct direction.

Thanks in advance.

Subject: HELP… Opening Document

Hi…

Please if anyone can suggest anything for this requirement, I would be thankful. If you are not clear about the requirement, pls post ur question and I will answer.

Thanks