L
Liz23
Currently I have a form that reads from a appended table and pulls in new
records every time the "Next" button is clicked.
My problem is that there may be multiple users using the same database and I
want to avoid the problem of two people pulling in the same record on their
form.
I want to run a code on the "Next" button that does 3 things to the appended
table:
1) Unchecks the edited record just worked on
2) Searches for the next unchecked record
3) Checks the record that is brought into the form
Does anyone have any suggestions for possible code that could do this?
records every time the "Next" button is clicked.
My problem is that there may be multiple users using the same database and I
want to avoid the problem of two people pulling in the same record on their
form.
I want to run a code on the "Next" button that does 3 things to the appended
table:
1) Unchecks the edited record just worked on
2) Searches for the next unchecked record
3) Checks the record that is brought into the form
Does anyone have any suggestions for possible code that could do this?