I have a textbox for setting the Project Priority. ProjectPriority
This is a number 01, 02, 03, 04, ...
I would like to have the ProjectPriority automatically change when the project is awarded.
That is, when the DateAwarded is entered, can I have the ProjectPriority change to "Obligated"?
In addition, I want to have this record for the control, change to "Obligate", so I can query the table (ProjectT) later and filter out all the Obligate to show only the Project Priority projects.
In Access I would put: =IIf(IsNull([DateofAward]),[ProjectPriority],"OBL")
but in VBA I'm not sure what to do.
My thought was to use an Event for the Project Priority textbox.
Not sure which one.
Thanks for any help!
This is a number 01, 02, 03, 04, ...
I would like to have the ProjectPriority automatically change when the project is awarded.
That is, when the DateAwarded is entered, can I have the ProjectPriority change to "Obligated"?
In addition, I want to have this record for the control, change to "Obligate", so I can query the table (ProjectT) later and filter out all the Obligate to show only the Project Priority projects.
In Access I would put: =IIf(IsNull([DateofAward]),[ProjectPriority],"OBL")
but in VBA I'm not sure what to do.
My thought was to use an Event for the Project Priority textbox.
Not sure which one.
Thanks for any help!