A
Alan
I have several years experience with Access queries and other
reporting uses but very little experience with forms designed for
inexperienced users. I am using Access 2002 with a database with the
following:
Tables Fields
Classes ClassNo
ClassName
StuID
StartDate
EndDate
Students StuID
Name
Address
Events EventNo
StuID
EventDate
EventCode
Comments
I want to set up a form that allows inexperienced users to review
related data from the above three tables. I want the main form to be
tied to the Classes table and allow the user to select from a combo
box the ClassNo to be viewed. Then, I want all the students in that
ClassNo to be presented in a subform in datasheet view. When the user
is on a particular student's record in that subform, I want another
subform below it to present a subform of events for that student in a
datasheet view. I also want the user to be able to filter the events
in the last subform to only show those with particular EventCodes
which the user selects with a combo box.
Is it possible to do what I want? Can someone outline the steps I need
to take? Will any coding be required to do this because my
understanding of Access modules and code is extremely limited.
Alan
reporting uses but very little experience with forms designed for
inexperienced users. I am using Access 2002 with a database with the
following:
Tables Fields
Classes ClassNo
ClassName
StuID
StartDate
EndDate
Students StuID
Name
Address
Events EventNo
StuID
EventDate
EventCode
Comments
I want to set up a form that allows inexperienced users to review
related data from the above three tables. I want the main form to be
tied to the Classes table and allow the user to select from a combo
box the ClassNo to be viewed. Then, I want all the students in that
ClassNo to be presented in a subform in datasheet view. When the user
is on a particular student's record in that subform, I want another
subform below it to present a subform of events for that student in a
datasheet view. I also want the user to be able to filter the events
in the last subform to only show those with particular EventCodes
which the user selects with a combo box.
Is it possible to do what I want? Can someone outline the steps I need
to take? Will any coding be required to do this because my
understanding of Access modules and code is extremely limited.
Alan