Fastest most efficient way to populate an MS Access 2007 Listbox control
Posted on 2014-04-15
I have a form with a listbox on it that is currently being populated by a somewhat kludgy SQL statement as it's rowsource. The problem is that it's kind of slow loading. This list box will also be filtered by a wildcard textbox control as the end user sees fit. In an attempt to streamline the use of this form, I want to have the listbox load as efficiently as possible. Any help would greatly be appreciated.
PS - I'm using a concatenated field to search filter via the wildcard textbox control filter.
Here's the where clause I'm using:
WHERE (((tblAssetAuditLog.UDb & tblAssetAuditLog.UNum & " - " & tblAssets.Desc) Like (IIf(nz([Forms]![frmAssetAuditLogSearch]![txtFilter],"")="","*","*" & [Forms]![frmAssetAuditLogSearch]![txtFilter] & "*"))))