We have an Access database which records the status of completion and other information about most publications and products created or distributed by our office.
Encluded on the main input form are tabs which display all sorts of data, deadlines, costs, etc. about the items. One area tracks the phase status of the items in a subform pull down combo box. Each item can go through from 2 to 12 phases before completion. Phases can be different for each item type That's why a combo box is used to allow for the differences. There are three phase related fields. (Phase name, expected "in-phase" date and the actual "inphase" date. This works well; however we would like for the current phase and actual received date to show on the main form at all times. Whenever the item enters into a new phase, we would like the current phase and date to be automatically updated. All previous phases and date will continue to be shown in the list.
Thanks for your help. Hope this makes sense.
Start Free Trial
