Accentually I have two questions:
1. on my form I have a cascading combobox that populates "city and productcode" on the form. the dropdown displays two columns and is saves the first bit to "city" on my table.. I want the selection to save to the first bit to city and second bit to productcode on the table respectively.
2. Days remaining on my form counts down from "Dispatch Due". This has condition formatting and changes colour as days count down. Green when first entered and Red closer to the due date. I would like this to turn Orange say 10 days from entered date and 5 days from due date.
Any help or pointers would be appreciated, I have uploaded my database so you can see what I'm talking about...
thanks in advance