Help!
I am trying to replace the Access Find button functionality on an old database.
I can make it work when I use a basic form with bound fields and a button which shows a popup form which then finds the record the user wants then does a GoToRecord on the basic form.
However...
When I try to put this to work in the real world the form with the record context to GoToRecord is a subform and it only partially works.
That is to say if I add a button to the subform and use it to do the GoToRecord action it works...
But if I use the same button, call the popup form and THEN do the GoToRecord it fails...
-
Private Sub cmdFind_Click()
-
DoCmd.OpenForm "NewSearchForm"
-
DoCmd.GoToRecord , , acGoTo, 612
-
End Sub
-
This fails...
If I take the OpenForm command out it works...
I have tried various combinations of the GoToControl action and SetFocus method as well to try and set the context correctly but, nope, it does not work
(as recommended here http://support.microsoft.com/kb/92685 )
ANY ideas gratefully received...
Martin