Recent content by robojeebus

http://www.vol-ume.com/mhs.mdb here it is

second way would be preferable as values could indeed change as you say, current drop down is populated by a 1 column table but I guess I can add a column with values.

I have exactly as you suggest Field one is titled priority: this field is the drop down Field two is Order Date: this is populated with todays date as the order is entered onto the database on the day it is recieved. Field this is job completion date: this is the field which needs calculating...

I have a drop down box in my access database which I want to use to give completion dates to jobs, the drop down has three values: Emergency Urgent Routine emergency equates to 1 day Urgent 7days Routine 28days I have had a dig in the help files and I can get the order completion date to...

I have a drop down box in my access database which I want to use to give completion dates to jobs, the drop down has three values: Emergency Urgent Routine emergency equates to 1 day Urgent 7days Routine 28days I have had a dig in the help files and I can get the order completion date to...