Forum Discussion
Checkbox on Report for individual student who paid fee linked with form (MS Access)
Hey Buddies.... I am stuck need your help....
as in below image 1 this is the student form first circle is faculty if i select the faculty from combo box then the another circle is the fixed admission fee updated in the bank statement which is shown in 2nd image and the 3rd image is the detail of all student paid unpaid students i cant delete that student data because he must be in list that bank slip has been generated for him. i want set all students amount in image 3 to zero and make checkbox which work for individual student if i check then the payment go to their textboxes and if i uncheck it remain zero. but for this i need make checkbox on report because easy to find the name number etc but i dont know how to give command on a report checkbox which lead me to form textbox. because i cant edit or enter text in report directly. i will get help from form. and the command not work direct on checkbox in VBA for checkbox. so first i have to go to form then textboxes.
if student paid the fee then his checkbox on report be like this its an example.
as we give command to a checkbox in form as below
if checkbox01 = uncheck then
admissio fee = "0"
security = "0"
else
form!details!admission fee = admission fee (which is fixed)
form!details!security = admission fee (which is fixed)
endsub
so how can i give command from a report checkbox to use the data from one textbox to another textbox in a form. is it possible?
in other words handle form from report checkbox with command.
2 Replies
- testmutsBrass Contributor
It is possible to do it with a checkbox. Look in a previous answer on a posting of me how to do this.
I think your aproach is not the correct one. I think you would be better of with a subform mentioning the costs. It would mean you can also have more years in this database then only one.
Good design is half the work 😉
Marcel