What I want to do is this:
On my form, (only one exists) when any one of the 3 combo boxes (each is referanced to a value list) are updated (On Update) I want another box to automatically update.
I've placed this event procedure into the "On Update" property of each box:
=IIf(([Equip Review Status]=("N/A" Or "Accepted") And ([Formu Review Status]=("N/A" Or "Accepted") And ([Mat Review Status]=("N/A" Or "Accepted"),[Preliminary Design Review Status]="Reviewed",[Preliminary Design Review Status]="Not Reviewed"
What's wrong with this. Im trying to say, "if all 3 are identified as "Accepted" or "N/A" the Review Status is "Reviewed", otherwise the Review Status is "Not Reviewed".
On update, i get a Type Mismatch error.
Thank you for any help,
Rob
On my form, (only one exists) when any one of the 3 combo boxes (each is referanced to a value list) are updated (On Update) I want another box to automatically update.
I've placed this event procedure into the "On Update" property of each box:
=IIf(([Equip Review Status]=("N/A" Or "Accepted") And ([Formu Review Status]=("N/A" Or "Accepted") And ([Mat Review Status]=("N/A" Or "Accepted"),[Preliminary Design Review Status]="Reviewed",[Preliminary Design Review Status]="Not Reviewed"
What's wrong with this. Im trying to say, "if all 3 are identified as "Accepted" or "N/A" the Review Status is "Reviewed", otherwise the Review Status is "Not Reviewed".
On update, i get a Type Mismatch error.
Thank you for any help,
Rob