Writing macro to go to specific record

[johnjmcnaughton]

I used the On Open code and that worked beautifully.
I ended up changing a little bit of the syntax of the code to make it like this:
DoCmd.OpenForm “Purchase Orders”, , , "PurchaseOrderID =" & Me.PurchaseOrderID , , , "Any text"

And it WORKS!!!!



I cannot thank you enough! You have been very helpful and patient with me!

[johnjmcnaughton]

Ok Bob, One last question.

I didn't realize it until now, but when I used the "On Open" code:
If IsNull(Me.OpenArgs) Then
DoCmd.GoToRecord , , acNewRec
End If

It stopped opening to a New Purchase Order. When I open the database that form opens but it doesn't open to a New Purchase Order anymore, it opens to the first Purchase Order. I imagine a slight change in that code would work.

Any Ideas?

Ok, sorry for this but I just realized that when I first open the database, the Security Warning Certain content in the database has been disabled thing is causing this problem. As soon as I click on the "Options" button and "Enable this content" it DOES change it to a New Purchase Order. But before I do this it is open to the First Purchase Order. So, with this new update I don't see it as important as before.

[Bob Fitz]

Perhaps you only need this line of code in the On Open event:
DoCmd.GoToRecord , , acNewRec

[johnjmcnaughton]

Well, I tried that and it stopped working on the other end (when double clicked in other form). So I think it is something I can live with.

Thanks again!