ansaurus

Question

Answer 1

A:

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.

BenV 2010-04-08 02:58:54

The list box contains a query.SELECT [Name] FROM MSysObjects WHERE [Type]=5 And Left([Name],1)<>"~" ORDER BY [Name];

Jeremy 2010-04-08 04:02:41

CurrentDB.Execute does not work on anything but DDL or DML statements, i.e., no SELECT.

David-W-Fenton 2010-04-11 02:12:31

You're exactly right. I assumed he wasn't doing a select since he wanted to execute it in the background.

BenV 2010-04-11 02:27:41

I would have assumed the same thing. I don't think it's a very good UI, to be honest.

David-W-Fenton 2010-04-11 21:04:34

Linking individual queries in a unbound listbox in ACCESS 2007