Tim-
You need code in the AfterUpdate event of the combo box to validate the student name and course chosen, make sure the student isn't already registered, then add a row to your registrations table. I suggest that your form also have a subform that lists the courses the student has already chosen. That subform would have to be requeried after you add each new registration to show the new record.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Oct 23, 2014, at 10:41 PM, timdbui@gmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
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: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar