Hi Macropod,

I hope you are well. Sorry for the long delay, the document is working great, thank you for your input.

There was one other adaptation I would like to make if possible but I am struggling to find a solution.

Is possible to use a combo box instead of a dropdown as the 'subject' box? And how would I code for that instead (do I just change the name 'DropdownList' to something else)?

The reason being, there will be one off field trips where the subject is not run in that time session. So for example, if there were to be a morning trip to a museum for Year 1 students, I would like to be able to type 'museum trip' in the subject box instead of selecting a predetermined subject.

Thanks

Megan