I have a form that I use to create training records for employees to go on courses.
When attempting to put an employee on a course, I want to check that they have completed the pre-requisite courses (or are at least scheduled to do them).
I have two recordsets - one to select the pre-requisites for the course (rs), and one to select any training records for each of those pre-requisites (rs_Pre_Req).
Once I find any pre-requisite course that they have not done and are not scheduled to do, I have a line of code to close the pre-requisite recordset (rs_Pre_Req.Close), and move to the last record of the other recordset (rs.MoveLast).
Outside my FOR loop, I have code to close the rs if it at EOF - but having put a breakpoint on that line, it apparently is not at EOF, even though I have moved to the last record!
Can anyone help with this?
Thanks
Jennie.
When attempting to put an employee on a course, I want to check that they have completed the pre-requisite courses (or are at least scheduled to do them).
I have two recordsets - one to select the pre-requisites for the course (rs), and one to select any training records for each of those pre-requisites (rs_Pre_Req).
Once I find any pre-requisite course that they have not done and are not scheduled to do, I have a line of code to close the pre-requisite recordset (rs_Pre_Req.Close), and move to the last record of the other recordset (rs.MoveLast).
Outside my FOR loop, I have code to close the rs if it at EOF - but having put a breakpoint on that line, it apparently is not at EOF, even though I have moved to the last record!
Can anyone help with this?
Thanks
Jennie.