开发者

Linking individual queries in a unbound listbox in ACCESS 2007

开发者 https://www.devze.com 2022-12-25 20:07 出处:网络
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社区 t

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.

0

精彩评论

暂无评论...
验证码 换一张
取 消