Retaining current record.

[mnsemple83]

A form for my database contains a button that will open a report in preview mode. When the user leaves preview mode, it returns them to the previous form. However, it will not display the record that the user was viewing before she opened the report and instead displays the first record in the database. How do I retain that record so that it doesn't change when the user leaves the report?

[Robeen]

Look in your Form's Properties -> Events -> OnActivate and see if there is a Me.ReQuery.

If so - that is 're-setting' the Form to display the first record in the Table.

If not, see if you can find the 'ReQuery' keyword either in one of your Form's Events - or in the code that is executed when you close your Preview.

[mnsemple83]

I eliminated all code containing "Requery" but the problem still exists.

Is there a way to create a variable that can be used throughout the database?

[rpeare]

Are you closing your form when you open the report or leaving it open?

If you're closing the form, just leave it open when you close the report it should go back to the record you were on since you've already said you are not performing any requery/refresh function.

[mnsemple83]

Yes, I am closing the form when I open the report.

In my code, I did not write any command for closing the main form. I am opening the report in print preview and that's when the main form closes automatically.

Prior to the report appearning, a dialog box appears with the main form in the background asking the user to select data for the report. Once the user clicks 'OK', the main form and the dialog box close, and the report is displayed.

[mnsemple83]

I am thinking of writing a function that can be used by all objects in the database. I want this function to store the record before the form closes and once the user closes the report, the function gets that record and returns it to the database so that the record is displayed.

Is this an efficient solution?

[APD]

I don't know if this helps, but I have a database with a form which has a button to open a report. My database uses a switchboard, and my form is set to open in add mode rather than edit mode, therefore the user can enter records, but is unable to access existing records through the form. The user can use the button to open the report, and when the report is closed the user is right back on the entry form where they left off.

Hope this helps

[RuralGuy]

You do not need to close the Form. Just set it invisible and use the acDialog argument of the OpenReport command to halt the code in the first form. Then set the Form visible when the code returns.

[rpeare]

As RG said, you don't need to close the form at all, just open the report in print preview, when you close the report it will go right back to where you were on the previous form.

[mnsemple83]

I just set the form to be invisible when the button is clicked and when the form is re-opened, I made it visible. The same record reappears so it worked. Thanks.

[RuralGuy]

Glad we could help. Thanks for posting back with your success.