Hi, I'm not a programmer, but have developed an access database to be used by church volunteers.
One table and corresponding form is used to enter basic information about a family coming for assistance at the church. The first time the family visits the church there is a checkbox called "new family" that is checked to indicate this is their first visit. If the family returns for a subsequent visit, the checkbox needs to be unchecked as they are no longer a "new" family. Currently the data entry person is asked to do this manually. They often forget. Is their a simple way to have the checkbox revert to unchecked when the record is opened a second time?
Sorry if this seems a bit vague.
Thanks for any advice.
Barbshop
One table and corresponding form is used to enter basic information about a family coming for assistance at the church. The first time the family visits the church there is a checkbox called "new family" that is checked to indicate this is their first visit. If the family returns for a subsequent visit, the checkbox needs to be unchecked as they are no longer a "new" family. Currently the data entry person is asked to do this manually. They often forget. Is their a simple way to have the checkbox revert to unchecked when the record is opened a second time?
Sorry if this seems a bit vague.
Thanks for any advice.
Barbshop