OK, I'm stuck, can someone please help?
I have a form on which users select a course reference from a drop down list. The course details are displayed and the user then click on a button to book a candidate on that course. When the user click on the button a subform (Candidate Subform) appears on the main form (Course Booking) which is done using the Visible method.
The user enters the Candidates title (Mr, Miss etc) and the First Name and Surname. The Candidate Number is generated using Access 2000 Autonum field type.
When the user has entered the surname a seperate form (Candidate Exists Form) appears if the surname and first name are already in the database, IE the candidate has already done a course in the past. If the correct candidate is displayed on the Candidate Exists Form then they click on the Candidate Number and the Candidate Exists form closes and all the Candidate Details appear in the Candidate Subform on the Main form.
The last bit is the part I can't get. I can get it to work if I open the Candidate Subform but this is a new subform and is not part of the Main form. Can anyone help?
I have two tables, Candidate and Course_Details.
Thanks
Craig
I have a form on which users select a course reference from a drop down list. The course details are displayed and the user then click on a button to book a candidate on that course. When the user click on the button a subform (Candidate Subform) appears on the main form (Course Booking) which is done using the Visible method.
The user enters the Candidates title (Mr, Miss etc) and the First Name and Surname. The Candidate Number is generated using Access 2000 Autonum field type.
When the user has entered the surname a seperate form (Candidate Exists Form) appears if the surname and first name are already in the database, IE the candidate has already done a course in the past. If the correct candidate is displayed on the Candidate Exists Form then they click on the Candidate Number and the Candidate Exists form closes and all the Candidate Details appear in the Candidate Subform on the Main form.
The last bit is the part I can't get. I can get it to work if I open the Candidate Subform but this is a new subform and is not part of the Main form. Can anyone help?
I have two tables, Candidate and Course_Details.
Thanks
Craig
