Results 1 to 3 of 3
  1. #1
    mermaidboy is offline Novice
    Windows 10 Access 2016
    Join Date
    Dec 2015
    Posts
    13

    Runtime error 459

    Hi,

    I have a procedure set to run as follows on OrderForm:

    Private Sub Form_Current()
    If [Forms]![OrderForm]![Checked?] = True Then
    Me.AllowEdits = False
    Else
    Me.AllowEdits = True


    End If

    End Sub

    It worked fine for several weeks, and then started giving me a runtime 459 error message when I tried to open the form.

    Any clues?

    Thanks,

    Nick

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,975
    Error 459 = "Object or class does not support the set of events"

    This suggests one of the following:
    a) a VBA library reference is MISSING - check and replace if so
    b) the form or control may be corrupted
    First try doing the following: compiling then compacting the db
    If that doesn't solve it - replace the checkbox, save & try again
    If that still doesn't solve it - create a new copy of the form
    Save a copy of the original form before changing it ... just in case

  3. #3
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    rename the checkbox without the ?.
    but, OrderForm MUST be open.

    Code:
    Private Sub Form_Current()
    Me.AllowEdits= not Forms!OrderForm!Checked.value
    End Sub

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Runtime Error 462
    By AccessPower in forum Programming
    Replies: 4
    Last Post: 01-11-2017, 03:44 PM
  2. Replies: 3
    Last Post: 02-26-2016, 12:34 PM
  3. Replies: 2
    Last Post: 08-22-2015, 11:26 AM
  4. Replies: 2
    Last Post: 10-15-2014, 04:23 AM
  5. Replies: 13
    Last Post: 06-12-2012, 09:52 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums