Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jun 2004
    Posts
    22
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I received the following error, "Run-time error 2448 You can't assign a value to this object."

    I have a command button on the main form that filters a subform check box.

    Here is the code:

    With Me.frmZip_info.Form
    .Filter = "Select = -1"
    .FilterOn = True
    End With

    Any ideas why?

    Thanks!

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    Is frmZip_info being used as a subform on a main form (whatever Me. is)? If so you need to reference it using the subform control name. Otherwise I don't see anything wrong with your code.
    Wendell

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts
    Quote Originally Posted by kgudgel View Post
    With Me.frmZip_info.Form
    .Filter = "Select = -1"
    .FilterOn = True
    End With
    Assuming frmZip_info is the name of the subform control, any chance this control is locked or not enabled? Or that the AllowFilters property of the subform itself is set to No?
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •