Hi all
I have a database containing information about students. On one of my forms the user selects a course number and student name and then a subform (based on a select query) displays other information about the trainee. Instructor comments etc.
At the moment whenever someone scrolls down to view all of the information on the (continuous) subform, after they have finished and wish to exit the main form a new record is created by the subform. How do I stop that from happening? I have the subform set for no additions, no edits, and Data Entry also set to no.
I'm sure I've seen a similar stiuation on here before but after all sorts of searches I haven't found the answer.
Any guidance appreciated.
I have a database containing information about students. On one of my forms the user selects a course number and student name and then a subform (based on a select query) displays other information about the trainee. Instructor comments etc.
At the moment whenever someone scrolls down to view all of the information on the (continuous) subform, after they have finished and wish to exit the main form a new record is created by the subform. How do I stop that from happening? I have the subform set for no additions, no edits, and Data Entry also set to no.
I'm sure I've seen a similar stiuation on here before but after all sorts of searches I haven't found the answer.
Any guidance appreciated.