one event only runs

[Guest]

Hi
I wrote following event

Private Sub Form_Load()
Dim MYCODE As String
MYCODE = InputBox("PLEASE ENTER CODE")
Me.CODE.SetFocus
DoCmd.FindRecord MYCODE
End Sub
which worked fine until i wrote second event
Private Sub manufacturer_Click()
Me.dateentered = Now
End Sub
when form opens nolonger runs form load event ??????
also i would like to open form showing only records where their is data in
manufacturer field how?
Thanks
Tina



tia
Tina

 

[Brian]

Hi
I wrote following event

Private Sub Form_Load()
Dim MYCODE As String
MYCODE = InputBox("PLEASE ENTER CODE")
Me.CODE.SetFocus
DoCmd.FindRecord MYCODE
End Sub
which worked fine until i wrote second event
Private Sub manufacturer_Click()
Me.dateentered = Now
End Sub
when form opens nolonger runs form load event ??????
also i would like to open form showing only records where their is data in
manufacturer field how?
Thanks
Tina



tia
Tina

In the properties sheet for the form, make sure that the "On Load" property
on the Events tab is set to "[Event Procedure]"

 

[Dirk Goldgar]

Hi
I wrote following event

Private Sub Form_Load()
Dim MYCODE As String
MYCODE = InputBox("PLEASE ENTER CODE")
Me.CODE.SetFocus
DoCmd.FindRecord MYCODE
End Sub
which worked fine until i wrote second event
Private Sub manufacturer_Click()
Me.dateentered = Now
End Sub
when form opens nolonger runs form load event ??????
also i would like to open form showing only records where their is
data in manufacturer field how?
Thanks
Tina

If you open the form's module in the VB Editor and click Debug ->
Compile on the menu bar, is any error highlighted?