err msg "sub or function not defined" for event procedure in repo

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

Guest

this is the event procedure:

Private Sub Detail_Format (cancel as integer, formatcount as integer)

If qrythingsnotworking![brakes] = "no" then

rptthingsnotworking [brakes].visible = true
else

rptthingsnotworking [brakes].visible = false
end if

end sub
 
Replace "qrythingsnotworking![brakes]" with the name of a control in the
detail section ie:
Me.txtBrakes
Also, does the field [brakes] actually contain the text value "no" or is
this a yes/no field?
If Brakes is a Yes/No field then the following should work if you have
txtBrakes:
Me.Brakes.Visible = (Me.txtBrakes = False)
 
Back
Top