M
Mandorallin
This is beginning to give me a real headache...
I have two tables with a one to many relationship. I have created a form
using these tables, one as the main form and one as the subform. For each
record in the main form, there are, at most, three records in the subform.
The tricky bit: I have created a new text box in the subform via the form
design. I need to enter coding somewhere using VBA in order to successfully
do the following...
In the new created text box, the value depends on the other records in the
subform. How do I tell Access to do a particular sum to work out the value by
checking a particular part of the other records?
I know how to do the sums, I don't know how to say "check other records in
the subform for this particular record in the main form." sorry if this isn't
very clear. I need someone to try and help me by being as simple as possible.
Thankyou.
I have two tables with a one to many relationship. I have created a form
using these tables, one as the main form and one as the subform. For each
record in the main form, there are, at most, three records in the subform.
The tricky bit: I have created a new text box in the subform via the form
design. I need to enter coding somewhere using VBA in order to successfully
do the following...
In the new created text box, the value depends on the other records in the
subform. How do I tell Access to do a particular sum to work out the value by
checking a particular part of the other records?
I know how to do the sums, I don't know how to say "check other records in
the subform for this particular record in the main form." sorry if this isn't
very clear. I need someone to try and help me by being as simple as possible.
Thankyou.