form & report control not update(?)

  • Thread starter Thread starter Mary
  • Start date Start date
M

Mary

HELP!

I call a report from a form via a button. The calling
form has previously (to clicking the button for the
report) calculated a dollar amount for a bound control to
display. This form is data entry, with edits and adds, no
deletes.

The dollar amount shows correctly on the form but not in
the table even though the record has been created. Since
the table shows zero for this dollar amount for this new
record and the form shows zero on the report, I am
certain this is some kind of update issue, but I cannot
find out what. Once the form is closed the table is
updated and all is good. However, I need my report to
reflect the dollar amount as indicated on the form (and
prior to table updating).

Can someone help me solve this (probably minor to you
gurus) dilemma?

Thanks,
Mary
 
Mary said:
I call a report from a form via a button. The calling
form has previously (to clicking the button for the
report) calculated a dollar amount for a bound control to
display. This form is data entry, with edits and adds, no
deletes.

The dollar amount shows correctly on the form but not in
the table even though the record has been created. Since
the table shows zero for this dollar amount for this new
record and the form shows zero on the report, I am
certain this is some kind of update issue, but I cannot
find out what. Once the form is closed the table is
updated and all is good. However, I need my report to
reflect the dollar amount as indicated on the form (and
prior to table updating).
Click to expand...


It sounds like you didn't save the record before printing
the report. If so, just add:

If Me.Dirty Then Me.Dirty = False

before the line code to ope the report.
 
Marsh,

Thanks so much. That works! Appears so simple, yet I lack
the knowledge. I'm glad you folks are around.

Thanks again,
Mary
 
Back
Top