Hello All,
I have a DB that contains a form (based on a table) where the user raises a Non-Conformance.
Part of the procedure for completing the form is to select a Category (Critical, Major or Minor) from a combobox named cboCategory.
There is also a field named Due Completion Date which is formatted as a General Date.
What I would like to happen is that when the user selects Critical from the combobox, the Due Completion Date is populated with today’s date plus 24 hours or 1 day, selects Major and the Due Completion Date is populated with today’s date plus 72 hours or 3 days, selects Minor and the Due Completion Date is populated with today’s date plus 168hours or 7 days.
I have tried using IIF statement, but my VBA knowledge is letting me down.
Can this be achieved and does anyone know of the best way to achieve this?
Many thanks