Search code examples
sqlsql-serverms-access-2016

Fire the Row Source (Pass through) query on request (Not on Load)

I am developing an application using MS access 2016. In my form I have a list with a "Pass-Through" query as the row source.

The pass through query is fired when on load the form. But I want to load/display the data in the list only when the user request (button click). How can I achieve this?

Solution

  • Leave the RowSource of the listbox empty initially.

    Fill it when the user clicks the button.