Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Microsoft: Access Forms FAQ


How can i improve the performance of comboboxes,listboxes and subforms ? by Chance1234
Posted: 9 Nov 04

take out the rowsource values of these controls and place the SQL in the tag property of the control.

then on your form_load event add the following

Private Sub Form_Load()
 Dim ctrl As Control

    For Each ctrl In Me.Controls
    Select Case ctrl.Properties("ControlType")
        Case acComboBox, acListBox
            ctrl.RowSource = ctrl.Tag
        Case acSubform
            ctrl.Form.RecordSource = ctrl.Form.Tag
        Case Else
            'do nothing
    End Select
    Next ctl
    Set ctl = Nothing
End Sub

You can also add in to the unload event, the same code above with the rowsource value set to ""

you will notice a dramatic improvement with speed with the above

Back to Microsoft: Access Forms FAQ Index
Back to Microsoft: Access Forms Forum

My Archive

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close