For the cascading combo boxes, I have tried various code in VBA, which isn't working and have just tried through use of a query, however which works the first time, but after that you have to reload the form again for it to work again as he jobs stay the same regardless of the first combo box.