keek2a4
03-25-2008, 08:10 AM
Hello People,
Need some help, heres my explanation..
I have three tables with the following fields:
1. tblStudent (studentID (PK), studentName)
2. tblSchool (schoolID (PK), schoolName)
3. tblExam (fkstudentName, mathResult, sciResult, engResult and fkSchoolName)
I have a form called "frmExamDetails" that has the table "tblExam" as a source record and using the form I can select a student Name from a dropdown and enter in the marks of the student name selected. I also have a field that displays the schoolName which cannot be edited. Hence I have text box's locked property set to "Yes" so it only displays the schoolName and does not let the user to edit it.
Here is my Question, I need a button named "Assign School" and when pressed, it displays a list of all the school Names in another form and when
double click on one of the names in the list, it changes the School Name in the first form. Could someone plz advise me on how to do this? I have attached a sample database will all the table and forms to give you a clear picture.
Thanks,
(ps I cannot use a Dropdown for the school Name, I am required to only use the methoded mentioned above?)
Need some help, heres my explanation..
I have three tables with the following fields:
1. tblStudent (studentID (PK), studentName)
2. tblSchool (schoolID (PK), schoolName)
3. tblExam (fkstudentName, mathResult, sciResult, engResult and fkSchoolName)
I have a form called "frmExamDetails" that has the table "tblExam" as a source record and using the form I can select a student Name from a dropdown and enter in the marks of the student name selected. I also have a field that displays the schoolName which cannot be edited. Hence I have text box's locked property set to "Yes" so it only displays the schoolName and does not let the user to edit it.
Here is my Question, I need a button named "Assign School" and when pressed, it displays a list of all the school Names in another form and when
double click on one of the names in the list, it changes the School Name in the first form. Could someone plz advise me on how to do this? I have attached a sample database will all the table and forms to give you a clear picture.
Thanks,
(ps I cannot use a Dropdown for the school Name, I am required to only use the methoded mentioned above?)