one event only runs

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
tina said:
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
Click to expand...

In the properties sheet for the form, make sure that the "On Load" property
on the Events tab is set to "[Event Procedure]"
 
tina said:
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
Click to expand...

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