C
cpmikey21
Hi everyone,
Somewhat new to Access databases, and I have a problem that I
can't seem to fix. I don't know the correct grammer to use for what I
want my db to do. I have a form and a subform. I need to update a
field in the table the form is getting its data from. Onto the
explanation.
The subform has a textbox which sums the values in the footer and
that works fine. I have a textbox referencing that value in the main
form. That also works fine. What I need it to do is to store that
value in a field in the table.
I know I could always perform the query if I wanted to value, but
I need to import the main form's table into another program, and if the
totals are included in that table, then I don't have to import the
other tables, which will save a lot of trouble down the line. I have
tried macros, and explicit code on the events After Update, and On
Change on both the subform's summing textbox, and the main form's
textbox referencing the subform's textbox. The grammer is probably
where I am getting messed up. I have tried various things such as
me.parent, the bang, set value ... And nothing seems to work. If
anyone can help, here are some variables you might need for an
example.
subform name: DL Helicopter Hobbs Query subform
subform total box: Gtotal
form name: 0 Daily Log
box referencing subform total box: txtHeliHobbsTotal
box I want the value to appear in: txtHeliHobbsGTotal
(which is referencing the form's table's total field)
Somewhat new to Access databases, and I have a problem that I
can't seem to fix. I don't know the correct grammer to use for what I
want my db to do. I have a form and a subform. I need to update a
field in the table the form is getting its data from. Onto the
explanation.
The subform has a textbox which sums the values in the footer and
that works fine. I have a textbox referencing that value in the main
form. That also works fine. What I need it to do is to store that
value in a field in the table.
I know I could always perform the query if I wanted to value, but
I need to import the main form's table into another program, and if the
totals are included in that table, then I don't have to import the
other tables, which will save a lot of trouble down the line. I have
tried macros, and explicit code on the events After Update, and On
Change on both the subform's summing textbox, and the main form's
textbox referencing the subform's textbox. The grammer is probably
where I am getting messed up. I have tried various things such as
me.parent, the bang, set value ... And nothing seems to work. If
anyone can help, here are some variables you might need for an
example.
subform name: DL Helicopter Hobbs Query subform
subform total box: Gtotal
form name: 0 Daily Log
box referencing subform total box: txtHeliHobbsTotal
box I want the value to appear in: txtHeliHobbsGTotal
(which is referencing the form's table's total field)