Binding a calculated check box

[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.

 

[Guest]

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.