I attach my dbse “Completion matters”
First, go to the Form
Go to tab called chaps.
On that from there are a number of text boxes and corresponding tick boxes.
When I tick a box the text box turns colour red.
What I want to do is make a query that tells me which of the boxes is not red or
alternively is not ticked against.
At the moment there is no other code connection between thew boxes other than the colour red/ black.
The “ colour” code operates on the update of the check box.
What is the best way to run a query based on what I want to do, which is to tell me which text boxes do not have a tick against them?