Form data in a report

[Guest]

I have a form with calculations and it is subreport in a report. If I update
the form data and open report not all the data fields populate? What's
missing?

Thanks

 

[Guest]

Sorry, there is just not enough information to really offer any suggestions.

 

[Guest]

....Thanks. Ok...I have a form which has a number of text boxes that have
Dlookup functions that extract data from multiple queries. These text boxes
also contain formulas adding and subtracting other text boxes from within the
same form. When I use a combo box to drive the reference query results, on
the screen the Form will update, but when I execute a button to Open a report
in which I've imbedded this Form, not all the text boxes are updated. I've
tried to incorporate a Requery and Refresh to run prior to the report opening
but it doesn't change the results...

 

[Guest]

I have runinto situations where the requery method fails, and other similar
update issues. However, I have no good suggestions, to resolve the problem.

One thing you may be able to do (depending on the form) is in the
AfterUpdate event, use a statement to set the textbox back to the calculated
value you want. Essentially forcing Access to redo the calculation.

It's not pretty, but has shown some success.

Good luck.

Sharkbyte

 

[Guest]

Thanks for the follow-up, appreciate the suggestion.