Binding a calculated check box

  • Thread starter Thread starter emoffit8
  • Start date Start date
E

emoffit8

Is it possible to bind a calculated check box to a field in a table?? My
check box determines whether or not an individual is qualified at a certain
level based on his score entered elsewhere on the form. However, I want to
represent all his qualifications in a report and thought it would be best to
attach them to his record. Is this even possible or do I need to recalculate
whether or not he's qualified in the actual report?? Thanks in advance.
 
Hi emoffit8,

Generally you don't store something that you can calculate, but in answer to
your question, yes, you can have that checkbox bound to a field in your
table, and use an event procedure to update the value of it, eg: an after
update event on the score field might be an appropriate place.

Hope that helps.

Damian.
 

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

Similar Threads

Binding a calculated check box 2
Using Check Boxes to select items in an Access subform. 0
Storing Calculated Values in a Table -- BAD IDEA? 7
Clearing check boxes in a form 2
group by query bound to check box error msg this record is notupdatable. 4
Using check box to make record active 3
Filling a form field using check boxes 1
check box to update text box 10

Back
Top