Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003

    Unanswered: Reset rowsouce on close event?

    Does it reduce system overhead to reset the rowsource of list boxes on close?

    I am building them on load, and thought it might make sense to reset them to null on close but that gives me an error:
    "Run-time error '2467':

    The expression you entered refers to an object that is closed or doesn't exits."

    The function appears as follows:
    Private Sub Form_Unload(Cancel As Integer)
    Me.PermUserID.RowSource = ""
    Me.PermissionList.RowSource = ""
    Me.CurrentPerms.RowSource = ""
    End Sub

    I can just abandon this if it doesn't really buy me anything.

  2. #2
    weejas is offline Grumpy old man (training)
    Join Date
    Sep 2006
    Surrey, UK
    Provided Answers: 18
    I'm not aware of any profit in clearing the sources of listboxes, and it will very slightly increase your network demand - your files are a tiny bit bigger with the presence of the form unload code, and it will take that little bit longer for the file to close.

Posting Permissions

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