VBA to update Approve data via Userform

[ThereseW]

Hi I have a userform that users can log issues in, I have searched but having a hard time finding an answer to how can I update this so that another user (the approver) can open the form to cycle through records where Super_Mng (column N) and Date_Closed (Column O) is missing data.

So essentially approver would click a button, same userform would pop up only with the evaluation and follow up section enabled and it would only populate userform with other data if this section is blank... user then can click next to approve another record.

[DavidBowman]

To make things easier to work with I turned your data sheet info into a table using Ctrl+T. Then I added a control to your form called cmdNextReview. The code behind for that click event has the code to do what I think you want. See attachment.

[ThereseW]

Many thanks David that is perfect.... will note this for next forms