G'day Gurus,
As I began thinking about the data that I need to include in one of my reports I relized that I need to gather some extra data.
Each design change has a lifecycle with 7 basic states from not started through to closed. States 4, 5, and 6 have two posible sub-states that I need to capture and report. It is almost like having options.
My data entry form already records the 7 basic states. What I would like to do is have another field that records the sub-states if the design change is in one of those three states.
Will a ComboBox do this?
Do I need a test routine for the After Update event in the first text box? Something that will check for states 1 - 3 and 7 move on to the next field and if states 4 -6 require users to enter the sub-state.
Would a nested if-then-else routine do the job?
I did a forum search and found a thread that, on the surface, looked like it might be a similar situation but I didn't understand the multitude of code presented so couldn't determine if I could use that answer for myself.
Dave
As I began thinking about the data that I need to include in one of my reports I relized that I need to gather some extra data.
Each design change has a lifecycle with 7 basic states from not started through to closed. States 4, 5, and 6 have two posible sub-states that I need to capture and report. It is almost like having options.
My data entry form already records the 7 basic states. What I would like to do is have another field that records the sub-states if the design change is in one of those three states.
Will a ComboBox do this?
Do I need a test routine for the After Update event in the first text box? Something that will check for states 1 - 3 and 7 move on to the next field and if states 4 -6 require users to enter the sub-state.
Would a nested if-then-else routine do the job?
I did a forum search and found a thread that, on the surface, looked like it might be a similar situation but I didn't understand the multitude of code presented so couldn't determine if I could use that answer for myself.
Dave
