Return to Same Record after REQUERRY

[mdg]

I was wondering if anyone knew a way to return to the same record that was just created after a requerry. When I enter a new record in my 'ENTER DATA' form, the record does not show up on the Main Form until after I requerry (which is a button on my main form). However, the 'requerry' puts my record back at the beginning or wherever the 'go to record' function tells it to. THere is no selection in the 'go to record' for a newly created record. I hope I make sense here. Thanks for anyone that has a suggestion

 

[pbaldy]

Does this work for you?

http://www.baldyweb.com/Requery.htm

 

[mdg]

Thanks for your kind response. I gave it a try. However, How would I get the 'Main Form' to do this after closing the 'New Recored Form'. I modified the code to requerry the main form as Me.Requerry.MainForm but get an error. I think my syntex is off here.

Dim rs As Object
Dim lngBookmark As Long
lngBookmark = Me.CaseNumber
Me.Requery.FormOversightCaseTracker
Set rs = Me.RecordsetClone
rs.FindFirst "casenumber = " & lngBookmark
Me.Bookmark = rs.Bookmark
Set rs = Nothing

 

[pbaldy]

How about this one?

http://www.baldyweb.com/Bookmark.htm

And "Me" is a shortcut that refers to the form the code is in, so to requery a different form:

Forms!FormName.Requery

 

[mdg]

I should know that. Thanks for your help. That worked great!!!

 

[pbaldy]

Happy to help!