If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > PC based Database Applications > Microsoft Excel > Reset rowsouce on close event?

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 12-10-08, 12:36
jdostie jdostie is offline
Registered User
 
Join Date: Oct 2003
Posts: 103
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.
Reply With Quote
  #2 (permalink)  
Old 12-11-08, 09:47
weejas weejas is offline
Registered User
 
Join Date: Sep 2006
Location: Surrey, UK
Posts: 448
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.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On