Hi!
I'm working with Access 97.
I have a form linked to a table from witch i get informations on persons(name, adress, phone#... etc...).
This table might have up to 300-400 persons.
I have a sub form attached that shows the services(~from 1 to 20) received by each of these persons during a period of time.These informations come also from the same table.
Also in that sub form, i have a checkbox for each of the service received in order to select some of the services for futur use. When i click on the checkbox, it update the file column "select" with is a YesNo type of data.
My question is "how can i make a counter on the main form that would indicate me how many services i selected at all time?"
I'm working with Access 97.
I have a form linked to a table from witch i get informations on persons(name, adress, phone#... etc...).
This table might have up to 300-400 persons.
I have a sub form attached that shows the services(~from 1 to 20) received by each of these persons during a period of time.These informations come also from the same table.
Also in that sub form, i have a checkbox for each of the service received in order to select some of the services for futur use. When i click on the checkbox, it update the file column "select" with is a YesNo type of data.
My question is "how can i make a counter on the main form that would indicate me how many services i selected at all time?"