ms-access-2007listboxitems

Linking individual queries in a unbound listbox in ACCESS 2007

I have created a unbound listbox. I have the box showing a list of queries I want the use to be able to select. My problem is I don't understand how to get the submit button to select the currently selected query and run it.

So how do I link the submit button to the listbox and have each item in the box submit its own query.

Solution

  • Does the listbox contain a query name or the actual SQL? Either way, something like

    CurrentDB.Execute(Me![ListBox])

    in the submit button event handler should get you going in the right direction.