Help creating an invoice system

[dougeefresh]

Hi,

I've been working to create an invoice system for piano lesson.
What I did was to create a table containing student info and I feed this info into a form that shows name, lesson day, price, etc. per student. So this creates 20 invoices (20 students) with different name and lesson day.

I added a check box next to each lesson day to remove it from the invoice when the box is checked because sometimes students take time off and I don't bill the missing days.

I have created the invoice using a form and this form pulls every student info so I can cycle through them all. The problems here is, since I am using only one form for the invoice(and pulling data from a table to populate the form), when I take out a lesson day in student #1's invoice by checking the box, all the following student invoices inherit this and take the same day out of its form.

How can I make it so that when I do perform an action in the first instance of the form, it doesn't propagate throughout? There could be a fundamental flaw in this design so any help would be appreciated it.

To sum it up, I am trying to use one table with student info and one form to pull and display all the info (insert each student's info into individual invoice) but make individually unique changes to each student's form. Hope this makes sense.

Thanks!

 

[Atomic Shrimp]

It sounds like your checkbox control might not be bound to anything in your table(s) - unbound controls on continuous or datasheet forms will act alike for all records.

Open the form in design mode, select the checkbox control, then examine its Control Source property.

 

[dougeefresh]

Hi, Mike,

Thanks for the reply.
I am not actually using Control Source(it's blank). I am using After Update which contains a bunch of subroutines to hide the lesson day in the invoice and make the lesson fee value $0 for that day when the box gets checked.

I was trying to see if there is a way to make the textbox name as variable so every text box name would be different and feed the variable to the subroutines instead of hard-coded textbox names like I am doing now but I am not sure if that's possible.

Thanks.

It sounds like your checkbox control might not be bound to anything in your table(s) - unbound controls on continuous or datasheet forms will act alike for all records.

Open the form in design mode, select the checkbox control, then examine its Control Source property.