I have a database with multiple forms. Forms are F_Project, & F_Contract.
On F_Contract I have a textbox called AwardDate.
On F_Project I have a checkbox called ActiveAwarded.
What I want is, when the AwardDate is entered (or deleted), I want the ActiveAward changed to True (or False).
The F_Contract and F_Project have tables T_Contract and T_Project with unique IDs, ContractID and ProjectID.
I have query that relates the two IDs called TJ_ProjectContract.
To complicate it a little more, the F_Project may or maynot be open when the F_Contract is open.
I'm thinking an AfterUpdate event on the AwardDate textbox but not sure how to do it.
Is that enough info?
Thanks for any help.
On F_Contract I have a textbox called AwardDate.
On F_Project I have a checkbox called ActiveAwarded.
What I want is, when the AwardDate is entered (or deleted), I want the ActiveAward changed to True (or False).
The F_Contract and F_Project have tables T_Contract and T_Project with unique IDs, ContractID and ProjectID.
I have query that relates the two IDs called TJ_ProjectContract.
To complicate it a little more, the F_Project may or maynot be open when the F_Contract is open.
I'm thinking an AfterUpdate event on the AwardDate textbox but not sure how to do it.
Is that enough info?
Thanks for any help.