Refreshing Report Data

[rts]

Hello,



I have a report based off of a query. I am trying to get it to requery or refresh on GotFocus, but I can't seem to get anything to work. I've searched and tried different ways like Me.Requery, DoCmd.RefreshRecord, etc. but nothing seems to work. It seems like the GotFocus part is maybe part of the problem. For example, I have a button on the report that opens a modal dialog form to update data. When the "OK" button is pushed on that form and it closes, I assumed that would trigger the GotFocus event for the report in the background that opened the form. Am I mistaken? I even added Application.DoCmd.SelectObject acReport, "Report Name" to the code after the modal dialog form closes to try to trigger the GotFocus event, but the report doesn't requery. Any help would be greatly appreciated!!

Thanks

[pbaldy]

Why not just put the requery command with the full report reference either behind that close button or in the close event of that form?

[rts]

That was easy enough! Thank you much - I think I tried everything, but that. One more question - this query the report is based on is a parameter query wherein the user has to enter the Project Number to pull up the report. It's not the hugest deal for them to reenter when it requeries, but is there a way to pass that back into the requery so the report doesn't prompt for the user to enter it again? Thanks again for your help.

[pbaldy]

I would have the user enter the number on a form, and point the query there. You could have a button on that form that opens the report.

[rts]

That's a better way to do it! Thank you!!!

[pbaldy]

No problemo! I virtually always use forms to gather user input.