filtering a listbox using a textbox in ms access 2010
I would like to filter a listbox using a textbox in MS Access 2010. Can
anyone show me how to fix what I have below so that the textbox input
actually filters the listbox?
I have a listbox named lstbxClients whose contents I want to filter using
input from a textbox called txtFilterClients. The rowsource property of
lstbxClients is set to:
SELECT Clients.ClientNumber, Clients.FullName FROM Clients ORDER BY
Clients.[FullName];
The image below shows the layout, along with the property sheet and
expression builder open to illustrate the expression that I added to the
On Change event of txtFilterClients:
No comments:
Post a Comment