S
serviceman via AccessMonster.com
Here I am again!
I have a form SPT_HDR that gets data from table ATTENDANCE_HDR. It has a
subform that gets data from table ATTENDANCE. The two tables are linked by
the key columns EVENT_ID,LOCATION_ID, and EVENT_DAT. Table ATTENDANCE also
has as part of its' key column STUDENT_ID. When I open this form and select a
record in the parent table, the subform shows the correctly filtered records,
and using the record navigation buttons I see only the students that are
registered for the class shown on the main form. I have been trying to put a
combo box on the subform to look up by STUDENT_ID each record with no luck.
Anything I try either shows no data or every student, not filtering it by the
parent record. EVENT_ID is int, LOCATION_ID is int, and EVENT_DAT is datetime.
Can anyone give me an idea of what the query for the combo box should be, or
just what in the world I'm missing? I wouldn't think this should be so hard,
but i just can't get it!
Andy
I have a form SPT_HDR that gets data from table ATTENDANCE_HDR. It has a
subform that gets data from table ATTENDANCE. The two tables are linked by
the key columns EVENT_ID,LOCATION_ID, and EVENT_DAT. Table ATTENDANCE also
has as part of its' key column STUDENT_ID. When I open this form and select a
record in the parent table, the subform shows the correctly filtered records,
and using the record navigation buttons I see only the students that are
registered for the class shown on the main form. I have been trying to put a
combo box on the subform to look up by STUDENT_ID each record with no luck.
Anything I try either shows no data or every student, not filtering it by the
parent record. EVENT_ID is int, LOCATION_ID is int, and EVENT_DAT is datetime.
Can anyone give me an idea of what the query for the combo box should be, or
just what in the world I'm missing? I wouldn't think this should be so hard,
but i just can't get it!
Andy