Field timming!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I have a form in continuous mode. I have created an unbound text box in my
form and placed it in the footer of the form. In the control source property
of the unbound textbox has an expression created in the expression builder to
sum a field in my form. Lets call the field to sum: "Amount".

So whenever I plug in a number in the "Amount" field the contents of this
field in every record are summed and stored in the unbound textbox. The
problem is that it does this x seconds after. Furthermore, I need to copy the
summed value in the unbound textbox to a bound field of this form so I can
display it in my report.(I DO THIS BECAUSE SOMEHOW I CAN'T PRINT UNBOUND
FIELDS IN A REPORT).

So if the user enters a value in the Amount field and quickly prints a
report based on this form, there usually is a good chance that the unbound
textbox hasn't finished calculating the sum of the "Amount" fields in every
record. This results in false summations.

Is there a way of knowing when Access has finished processing the summing
task!
I thought of putting a timming delay code in the print button proceedure.
But there must be a better way!

Anyone Please.
 
Robert,
I'll help you out with this part: "I DO THIS BECAUSE
SOMEHOW I CAN'T PRINT UNBOUND FIELDS IN A REPORT)."

If you keep your form open while you open your report,
then your report can refere to an unbound control in the
form. The syntax is, if you are coding in the report:
Me.controlname.value = Forms("form1").Controls
("controlname").Value
If you are coding from the form the once the report is
open you can do:
Reports("report1").controlname.value = Me.controlname.Value

Good luck.
Geof.
-----Original Message-----
Hi,
I have a form in continuous mode. I have created an unbound text box in my
form and placed it in the footer of the form. In the control source property
of the unbound textbox has an expression created in the expression builder to
sum a field in my form. Lets call the field to sum: "Amount".

So whenever I plug in a number in the "Amount" field the contents of this
field in every record are summed and stored in the unbound textbox. The
problem is that it does this x seconds after.
Click to expand...
Furthermore, I need to copy the
 
Hey thanks for replying buddy!
I did try to reference the unbound field the way you showed me, however,
when my report prints out, it is behind my 3 opened forms. I tried to set my
the three form's modal property to no so I can see my report, but no can
do!!! So I still don't know if this works!

Anyhow if you have any ideas on how to set the form to not modal state, let
me know, cause I sure hell tried with no success

Thanking you in advance
Robert
 
Stupid me!!!!!!!!!!!!!!!!!!!!! all I had to do is set the popup property of
my report to "Yes".

Thanks a million buddy, It WORKS!!!!

Robert
 
Yeehaaw!
-----Original Message-----
Stupid me!!!!!!!!!!!!!!!!!!!!! all I had to do is set the popup property of
my report to "Yes".

Thanks a million buddy, It WORKS!!!!

Robert


.
Click to expand...
 
Back
Top