Using after update to uncheck box

G

Guest

Hello,

On my form I have a check box called "Qry_NPE" which is defaulted to "true"
and it indicates that the enquiry has no errors. The errors are on a subform
and I have a textbox that counts the number of errors.

I am trying to use the "after update" event in this text box to uncheck
"Qry_NPE" if there is at least one error. It doesn't quite work.

The errors subform is on a different tab to the "Qry_NPE" checkbox (if that
makes any difference).

Cheers!
 
G

Guest

Can you show us what you've got so far? You're telling that you want to
uncheck based on a after update from the textbox. In that after update Access
should know what to uncheck on which form and what the criteria for the
uncheck must be..
 
G

Guest

I want "Qry_NPE" on the main form to be unchecked when the number of records
in the subform is greater than zero.

Hope that is clearer.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top