Programming a counter for a library database

[gm_lowery]

Hi everyone,

I need a little bit of help. I built a library database for a client about a year ago. Now they have come back with a request to put in place a counter for how many times a book has been checked out. The problem is that there is no button that checks books out. They simply click a check box to indicate whether the book is available or not. Any ideas how I could program a counter for this/

Thanks.

[jzwp11]

You could add a long integer number field to the underlying table. Set its default property to 0. You will also have to update the field's value for all existing records to zero. Then in your form you could use some code in the on click event of the check box that increments the count if the check box is checked. I've attached an example database.

[gm_lowery]

This worked perfectly. Thanks for your help!

[jzwp11]

You're welcome.