Returning to record after viewing a report.

[Robert2150]

I have a button that opens a report for viewing when I have a specific record open. When closing that report view I want to reopen the data input form to the record that I opened report for viewing. At this time I can view the report, but upon closing my data input form opens, but to the first record. Can anyone give me some code to reopen my data input form to the original record?



Thank you in advance.

[June7]

Why close the form?

[Robert2150]

It seems that I need to close the form to view the report.

[June7]

Is the form Popup property set to yes? If you really must use Popup, possible code options:

1. code in the report Close event to open form filtered to recordID

2. pass value back to form to use in code behind form that filters form or moves to desired record

[Robert2150]

Yes it is a Pop Up.
The report is based upon the Property that is being viewed in the main form, the property number is the Record Number in the table.
After viewing the report and then closing it the main form reverts to the first record in the table.
Do you have any code examples of your reconmendations?
Thank you.

[June7]

Behind report, code like:

DoCmd.OpenForm "form name", , , "RecordNumber=" & Me.tbxRecordNumber

Option 2 would be more complicated.

Why must you use popup?

[Robert2150]

Thanks for the code, I will try it and let you know if it solves my problem.
I use popup to completely fill screen when form opens. (without toolbars, or navigation bar).
Thank You.