I have database that holds training courses, students and allocations on a course. The main form shows the course details. The lower half of the main form has a few pages, each with an embedded subform showing the students who are on the course. The first page shows the students on the course (i.e. name, company, email etc on a continuous form). The next page shows the student name, exam results etc (again continuous form).
I have placed a command button on the first page, embedded in the continuous form, to allow the student to be moved to another course. This opens another form in dialog mode which allows the new course to be selected, runs some SQL to update the allocations table and return to the original form. The vba code is
stDocName = "frmMoveDelegate"
DoCmd.OpenForm stDocName, , , stLinkCriteria, , acDialog
DoCmd.Requery
The requery does remove the student from the first page – showing the user that they have been successful. However, if you click on the second page the "moved" student is still there, like an after image. How can I refresh the data on all the pages associated with the course? It's probably a simple solution but I'm a bit stumpted at present and would appreciate some help.
Many thanks
Ray
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar