Hi
Anyone have the solution to this little problem?
I have a form (Pipeline) with an on load event that automatically directs the user to a new empty record.
Now my problem is that I am trying to design a 'search form' that will allow the user to look up a specific record in the main form by pressing a command button. Creating the search form is easy enough. I cannot figure out how to override the on load event in the main form when pressing the command button.
Any ideas?
As it is right now, the button opens the form and then go directly to a new record.
Anyone have the solution to this little problem?
I have a form (Pipeline) with an on load event that automatically directs the user to a new empty record.
Code:
Private Sub Form_Load()
DoCmd.GoToRecord , , acNewRec
End Sub
Now my problem is that I am trying to design a 'search form' that will allow the user to look up a specific record in the main form by pressing a command button. Creating the search form is easy enough. I cannot figure out how to override the on load event in the main form when pressing the command button.
Any ideas?
As it is right now, the button opens the form and then go directly to a new record.