i'm a hs teacher who took on a project over break (not paid). trying to use
access to streamline teacher recommendation process at our school. right now
each teacher has to fill out a paper form for each student to select which
subjects he/she recommends for the coming year. then guidance has to gather
all the paper forms and figure out which student was recommended for which
class(es), all this in a short turnaround timeframe.
needless to say its not very efficient so i volunteered to try and create a
program to do this so. interface to show list of students and subjects,
allow teacher to select student and subject, then run reports for guidance.
its turning out to be a bigger task than i thought (always is
but i'm
getting close
"Gina Whipp" wrote:
Oops forgot about that...
You can't use the wizard to link them... Go to Properties of the Subform
LinkChildField = NameOfStudentIDField in tblStudentSubjects
LinkMasterFields = NameOfComboBox on Main form
Student ID is blank because the form is not linked AND you need to create a
Relationship between the tables with Cascading Updates set to Yes...
You know I'm starting to get the impression I am doing your classwork for
you. Is this an assignment?
--
Gina Whipp
"I feel I have been denied critical, need to know, information!" - Tremors
II
"mike" wrote in message
...
Gina,
1. - 3. The combo box on the Main Form should be unbound. You do not
need
to save the value for anything.
got it.
4. Subform should be in continuous view and attached to the Main Form
(Link
Fields) StudentID. Then the field Student Subject should be a combo box
using the tblSubjects as the Record Source and the value should be bound
to
the ssStudentSubject.
-how do i (or when in the wizard do i) link the subform to the main form?
-tried setting "Source object" for subform to main form but when i try to
link child/master fields, get message stating "cant link unbound forms"
tried all above 1)new record is created in tblStudentSubject w/ correct
subject from cbo in subform but 2)studentID is blank.