Quick Easy Question

[brokenwh]

Good Morning:

I have one small questions and am having trouble with it.

I have a form with a macro button to preview a report based on a value in the form (PONo)

The report is based off of a query.
My question is - What can I do to make it so the report is "up to date" when the button is pressed? At this time, it is about three inputs behind unless you shut off the form, restart it and then go to the record you were working on.

Any ideas would be greatly appreciated!

 

[craw]

try looking into Requery

 

[brokenwh]

Still not working

I tried the requery and it changes the information on the form to the first one done instead of staying on the current form.

Any other suggestions?

 

[Lister]

In Design view on your form that has the “Button” that activates the macro, right click on it and select Build Event.
This should display you Macro in Design view. Insert a new row above the OpenReport Action and Select RunCommand from the drop down box.
Next in the Command Box at the bottom of the Macro Select SaveRecord. Save and close.
And that should do it, the extra line should save any new updates before it opens the report. So all the information in the report should also be up to date.
See how you get on.
Hope this is some help.

 

[brokenwh]

Thanks

Thanks - That made it work - I appreciate it!