Tim ,
This is typically accomplished with a main form that has the primary key from the student table and a continuous subform. The subform has a record source of the junction table that has the student primary key and the course primary key. The link master and link child properties of the subform are the student primary key value/field.
The subform displays a single combo box that has a row source like:
SELECT CourseID, CourseTitle
FROM tblCourses
ORDER BY CourseTitle;
The bound column is the CourseID. The column widths can hide the CourseID by setting the property to 0";2"
This allows the student to see all previous selections.
If you can't figure this out, please reply and include the previous messages in this thread as well as the significant table and field names.
Duane Hookom MVP
MS Access
Posted by: timdbui@gmail.com
This is typically accomplished with a main form that has the primary key from the student table and a continuous subform. The subform has a record source of the junction table that has the student primary key and the course primary key. The link master and link child properties of the subform are the student primary key value/field.
The subform displays a single combo box that has a row source like:
SELECT CourseID, CourseTitle
FROM tblCourses
ORDER BY CourseTitle;
The bound column is the CourseID. The column widths can hide the CourseID by setting the property to 0";2"
This allows the student to see all previous selections.
If you can't figure this out, please reply and include the previous messages in this thread as well as the significant table and field names.
Duane Hookom MVP
MS Access
Posted by: timdbui@gmail.com
Subject: [MS_AccessPros] Save record after select from a combo box
Would any of you please help me with this issue?
I have a form in which has 2 boxes:
Box 1: student puts in his or her name
Box 2 is a combo box where the student can select 5 to 7 courses from a list of some 50 available courses.
After the student put in his name in box 1, he will select courses from the drop down in the combo box #2.
How can I have Access 2013 to save the record of the first selection immediately after he select the first course, then save the second course after he selects second course, and so on.
What I am trying to do is to make it easiest for the student to select the desired courses.
Thanks in advance for your help!
Tim
Would any of you please help me with this issue?
I have a form in which has 2 boxes:
Box 1: student puts in his or her name
Box 2 is a combo box where the student can select 5 to 7 courses from a list of some 50 available courses.
After the student put in his name in box 1, he will select courses from the drop down in the combo box #2.
How can I have Access 2013 to save the record of the first selection immediately after he select the first course, then save the second course after he selects second course, and so on.
What I am trying to do is to make it easiest for the student to select the desired courses.
Thanks in advance for your help!
Tim
__._,_.___
Posted by: Duane Hookom <duanehookom@hotmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar