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开发者_StackOverflow社区 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.
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.
精彩评论