I am building a form that will be used by multiple people simultaneously to review a series of records, from a table called Review.
Some of the records in the list will already have been reviewed, and I would like the form to skip any such record (I know I can do this by filtering it to only show records where the status is null, but I'm not sure where to put that), additionally I need it to skip any record that someone else has open.
Lastly, depending on the disposition of the review I have three buttons that can be pressed, but I am unsure of how to code them to do what I want. For simplicity I'll call the three buttons Rejected, Previous and Accepted.
For the Rejected button, I need it to change the Status of the record in the Review table to Reviewed and change the Status of it in a 2nd table, called Input, to Rejected.
For the Previous button, I need it to change the Status of the record in the Review table to Reviewed and change the Status of it in a 2nd table, called Input, to Previous.
For the Accpeted button, I need it to change the Status of the record in the Review table to Reviewed, change the Status of it in a 2nd table, called Input, to Accept, and append the fields First Name, Last Name and Customer # to a 3rd table called Master.
I not very experienced at Access and I'm not really sure how to go about this kind of a process. If someone could point me to a place where I would be able to find this information or provide some information themselves, I would be greatly appreciative. Thank you in advance to anyone who may be able to help me.
Some of the records in the list will already have been reviewed, and I would like the form to skip any such record (I know I can do this by filtering it to only show records where the status is null, but I'm not sure where to put that), additionally I need it to skip any record that someone else has open.
Lastly, depending on the disposition of the review I have three buttons that can be pressed, but I am unsure of how to code them to do what I want. For simplicity I'll call the three buttons Rejected, Previous and Accepted.
For the Rejected button, I need it to change the Status of the record in the Review table to Reviewed and change the Status of it in a 2nd table, called Input, to Rejected.
For the Previous button, I need it to change the Status of the record in the Review table to Reviewed and change the Status of it in a 2nd table, called Input, to Previous.
For the Accpeted button, I need it to change the Status of the record in the Review table to Reviewed, change the Status of it in a 2nd table, called Input, to Accept, and append the fields First Name, Last Name and Customer # to a 3rd table called Master.
I not very experienced at Access and I'm not really sure how to go about this kind of a process. If someone could point me to a place where I would be able to find this information or provide some information themselves, I would be greatly appreciative. Thank you in advance to anyone who may be able to help me.
