If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
purpose of subform?
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. |
Thread Tools | |
Display Modes | |
|
|