Refreshing a Form Without Going to Record One

[jclover]

I have a form with a subform, and a child linked form.

The main form is a data entry point for different business tracking. The child form that is opened from that is used to enter product information, that when closed, refreshes the main form, so that the product information appears in the subform area. (Basically populating a list)

Right now on the "close/update" button of the child form, I have code that prompts the main form to refresh. (Forms![frmName].Requery)...the problem is, I don't know how to get it to refresh the data, but to stay on the selected record. The refresh resets the record to 1, and then I have to scroll back through to my selected record.

Ideas?

[ADezii]

I have a form with a subform, and a child linked form.

The main form is a data entry point for different business tracking. The child form that is opened from that is used to enter product information, that when closed, refreshes the main form, so that the product information appears in the subform area. (Basically populating a list)

Right now on the "close/update" button of the child form, I have code that prompts the main form to refresh. (Forms![frmName].Requery)...the problem is, I don't know how to get it to refresh the data, but to stay on the selected record. The refresh resets the record to 1, and then I have to scroll back through to my selected record.

Ideas?

Dim varBookmark As Variant   'will hold Current Bookmark
 
'Store the original Bookmark in a Variant
varBookmark = Me.Bookmark
 
'Requery the Form
Me.Requery
 
'Restore the original Bookmark
Me.Bookmark = varBookmark
 

[jclover]

Seems to solve my problem. Thank you.

[ADezii]

Seems to solve my problem. Thank you.

You are very welcome.

[jclover]

Frustrating. This was working a couple of weeks back, but when I revisit the database now, it's saying that it's "not a valid bookmark".

'Close the form I just entered the data into
DoCmd.Close acForm, "frmMPR_Price_Subform"
 
Dim varBookmark As Variant
 
'Store the original Bookmark of the sheet I want to requery to show the updated form
varBookmark = Forms!frmMPR.Bookmark
 
'Requery the Form
Forms!frmMPR.Requery
 
'Restore the original Bookmark
Forms!frmMPR.Bookmark = varBookmark
 

Then it errors out. Form resets to record 1.

Any help?