Conditional formatting, etc.

[topdesk123]

Hello!

I am using conditional formatting in a continuous form to highlight items that have been scheduled. There are 2 processes - cleaning and sealing, each is scheduled separately (sealing happens after cleaning). I have a field titled Scheduled - which updates to yes or no via update queries, it doesn't work well. What I want it to do is: when cleaning is scheduled, I want "Scheduled" to read yes, when cleaning is completed, I want it to read no. When sealing is scheduled, I want it to read yes. The information comes from a subform on the main schedule form, where jobs are assigned to employee(s). I have the update queries running after the scheduled date is updated. I think a Case...Else statement would be a better way to go about it but I'm not really sure how to write it.

Sorry if this is convoluted - it's in my head - just can't get it out!

TIA

Topdesk

 

[THWatson]

Topdesk
Not sure why you would need to use Update queries in this situation.

Have you tried putting code on the AfterUpdate event for your subform, so that when the schedule date is entered, the "Scheduled" field toggles to Yes, and when the cleaning completion date is entered the "Scheduled" field toggles to No?

Tom