Linking Subform to a Mainform

[Guest]

I have a mainform and subform. The mainform has only one field which is
"Date". The subform is in tabular format and contains a list of students
names. What I want to do is taking attendance for the students for every
different date. I need to move from record (Date) to another and add new
records (Dates) in the mainform without the content of the subform changes.
Is there any way to do that? Thanks

 

[Guest]

Hi, in order to answer your question I would need to know what your table
structure is like.

 

[Guest]

The tables I have are
tblDates: DateId (PK), Day
tblStudents: StudentId (PK), FirstName, LateName
tblStatus: StatusId (PK), Status.

What I have done before is adding DateId as a foreign key in tblStudents and
make a one to many relationship between tblDates and tblStudents. I linked
tblStudents and tblStatus as one to one relationship. Then I made tblDates as
the RecordSource for the mainform and qryStudentsStatus as the RecordSource
for the subform. The subform should contain FirstName, LastName and Status.
Doing so doesn't work as desired. See my first message...

I hope this explain the problem more...

"Reg Gibson" skrev: