I have a form based on a table called Students, it just displays their first name.
I have a subform where I want to display the classes the student is signed
up for. I have the following tables: Classes, Enrollments (StudentID,
ClassID), and Sessions (ClassID, Day, Time). I'm using all three of these
tables for my subform's record source and when I run my form it won't let me
input any data for a student.
I also want in my subform to have the ClassName be a combo box that displays
all classes from the Classes table.
Re: YAFSP Form/subform ... since you want the subform on all the pages, that is fine -- just wanted you to realize that it is really not on ANY of the pages... ... -- you should not have the SAME student in the Students table more than once -- use a related table for the combination of student and grade if you are keeping historical records. ... change the Name property of the control to something logical if it is ambiguous. ... (microsoft.public.access.formscoding)
Re: Subforms ...Emergency Contact Details: ...Student ID ...Provider Details:... Then a subform (Linked through the ... (microsoft.public.access.forms)
Re: Subforms ... A provided may be the provider for only part of a year (e.g. due to ... Once you have that, you can create a query based on tables Student,...Emergency Contact Details: ... Then a subform (Linked through ... (microsoft.public.access.forms)
Re: extra unwanted record entry from linked form/subform operation ... is true for the current record of the SubForm moving the focus the other way. ... command button titled submit so the next student can ... All of this with the instructor and course field being populated to ... I inserted a subform with the student info and the two main fields and ... (microsoft.public.access.forms)
Re: Need help setting a database up... ... that if you are entering student data into the subform,... then you won't be associating the student with the test. ... need to have an applicant in your database to assign to the test. ... Have the test location, time, date etc on the top.. ... (microsoft.public.access.tablesdbdesign)
