Results 1 to 2 of 2
  1. #1
    caddcop is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Feb 2011
    Location
    Upper Marlboro, Maryland, USA
    Posts
    57

    Error message with Event Properties on a subform

    I have a couple of main forms with sub-forms. They originated as one form which was copied to create the second form. I then replaced one of the sub-forms with a new sub-form.
    One of these functions as I want, firing off events as needed when certain events occur in both the main and sub-form parts.
    The other, when loading, presents me with an error dialog box.
    The massage in the dialog box is as follows:
    The expression On "some form event" you entered as the event property setting produced the following error: Object or class does not support the set of events.
    * The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure].
    * There may have been am error evaluating the function, even, or macro.

    Then, there is a show help button, which is naturally, of no help.
    If I remove all events from the sub-form properties, the errors go away, but then, nothing happens like I need it to.
    I also tried removing all form Events but leaving a single event on one of the form objects, a combo box. The event was a GotFocus event. Same error message.
    Somehow, no events seem to be allowed in this sub-form.


    Does anyone know how to fix this?

  2. #2
    caddcop is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Feb 2011
    Location
    Upper Marlboro, Maryland, USA
    Posts
    57
    Well, I fixed this, but why exactly it worked is beyond me. A basically took the form that would not work and made a new copy of it and replaced the original with the copy. There are no more errors.

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

Similar Threads

  1. AfterUpdate event won't refresh subform!
    By Remster in forum Forms
    Replies: 16
    Last Post: 11-26-2010, 10:06 AM
  2. Trigger subform event
    By tuna in forum Forms
    Replies: 0
    Last Post: 05-09-2010, 06:29 AM
  3. error message
    By ngeng4 in forum Forms
    Replies: 85
    Last Post: 03-25-2010, 06:47 AM
  4. Error Message in Access2007
    By Storm91 in forum Access
    Replies: 3
    Last Post: 02-18-2010, 02:56 PM
  5. If / Then Error Message
    By Schwagr in forum Forms
    Replies: 4
    Last Post: 03-30-2006, 06:28 AM

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