Hey guys,
So I've got a very basic problem, but i can't understand for the life of me how to solve it.
1. I have a main form
2. I have a sub form.
In the sub form it contains the Unit price, and quantity supplied. I added a text box into the sub form which is the product total. The product total is simply the quantity supplied * the unit price. This works fine. All i want to do is have a "product total option. on the main form, can be in the footer or the body of the main form, doesn't matter.
The problem is every time i use the Sum function in the text box ,to reference the sub form field of "product total" it just displays a #Error in the order total text box.
I've read some posts that say you can't use a calculated control to do a sum. So i tested this out on the same of quantity supplied (which is not a calculated field) and it gives and error as well.
I have been careful to reference the correct field in the sub form.
Just to note a few things. The only fields in the query were Unit price, and Quantity supplied. Product total was a added text box. Order total was an added text box into the form.
I just cannot get the sum function to work on the main form for anything. Any suggestions would be great.
Thanks,
NIck
So I've got a very basic problem, but i can't understand for the life of me how to solve it.
1. I have a main form
2. I have a sub form.
In the sub form it contains the Unit price, and quantity supplied. I added a text box into the sub form which is the product total. The product total is simply the quantity supplied * the unit price. This works fine. All i want to do is have a "product total option. on the main form, can be in the footer or the body of the main form, doesn't matter.
The problem is every time i use the Sum function in the text box ,to reference the sub form field of "product total" it just displays a #Error in the order total text box.
I've read some posts that say you can't use a calculated control to do a sum. So i tested this out on the same of quantity supplied (which is not a calculated field) and it gives and error as well.
I have been careful to reference the correct field in the sub form.
Just to note a few things. The only fields in the query were Unit price, and Quantity supplied. Product total was a added text box. Order total was an added text box into the form.
I just cannot get the sum function to work on the main form for anything. Any suggestions would be great.
Thanks,
NIck