copy forms and subforms 1

[bluebird4027]

Hi
i am creating a database for a school. At the top of the screen I have pupil info, ie name, dob, class, teacher etc and under that I have pages that show targets that every child has. ie COMMUNICATION/LITERACY is the target title and then the targets are then listed with the outcome of 'Achieved', 'Not Achieved' and 'Partially Achieved'.

This information needs to be entered for the previous 4 years and is an ongoing project - so what I thought I would do is have a different page for each year. I've created the the 2001 page with all 6 targets as subforms and I would like to copy this for the other years but when I have tried it and entered information, all years are then changed - so...how do you copy but make all subforms independent? or would every year have to have it's own table and form and then I have to build each page up...which has taken me ages!!! I'd be really grateful if someone could help.

Thanks in advance
Sam

 

[OnTheFly]

You would have to change the data sources to correspond with the years. Binding the forms to a query with the year as a criteria would seem to be the best method.

Hope this helps.

OnTheFly

 

[bluebird4027]

Hi OnTheFly
Thanks for that. I'm still not sure how you would do that though. If I am entering info for 2002 and then info for 2003, wouldn't everything I have entered go into one table? and if that was the case, how would I use dates to get the info needed?

 

[OnTheFly]

I am assuming you are also enter the year as a field or a date of some kind. I the query bound to the sub forms you would use something like the following:

SELECT * From tblTargets WHERE Year=2002

or

SELECT * FROM tblTargets WHERE TargetDate Between #1/1/2002# AND #12/31/2002#

Hope this helps.

OnTheFly