View Single Post
  #24  
Old April 16th, 2008, 02:05 PM posted to microsoft.public.access.forms
access user
external usenet poster
 
Posts: 78
Default Prevent edits - unexpected effects

not being the old hand with this product, got any suggestions re how to
tackle it?

"Allen Browne" wrote:

"Access User" wrote in message
...
Using the following now

Private Sub Form_AfterUpdate()

Call LockBoundControls(Me, Nz(Complete.Value, False), "Complete")

End Sub

Private Sub Form_Current()

Call LockBoundControls(Me, Nz(Complete.Value, False), "Complete")

End Sub

I get an error 424 - object required?


Will have to let you do your own debugging.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.