Class update

[drisconsult]

I have completed a school database for schools in Uganda, Tanzania and Kenya. The problem I am having is updating a class after a class has moved on to the new academic year. At the moment I am having to ask teacher's to do this manually. I'm afraid that my VB is not up to this task.

An example would be class 1A, which has 40 Students. In the next academic year this class would become 2A and so forth for all other classes.
Terence Driscoll
London

 

[Ranman256]

it is, but vb not required.
your database should have a year field on the Academic Year table.
each year would require a new student roster, (that can be copied from prev year)

 

[drisconsult]

Thank you for your reply, but unfortunately that was much too involved for me. At 86 years old my brain is not working ass well as it did. However I have found a solution based on one of the Forums experts who referred to my problem previously by using a ListBox. I have included a screenshot to show my solution based on the other experts solution and it works well enough.
May I thank you all for your patience. Terence Driscoll

 

[arnelgp]

You're welcome.