Hi All
I was looking for a little help with one of my forms which assigns an engineer to a job using a combo box which works fine - what I'm looking for it to do is to when you select a date I want it to lookup a query which list all the days and engineer has booked off and if any engineers are booked off for that date I would like when you look at the combo box the engineers that are not available to turn a different colour and can not be selected
I have had a look through the forum and on google but can't see anything that looks like this - I would really appricate if someone could point me in the right direction
cheers jackie