Help with SQL Query

[Alan]

I created a Multi Select list box.

I even got the code to create the SQL statement in a control called Item.
Forms!Form1!Item

Here is a sample of what appears in Item:
Select Name, activity from Table1 where [activity]=MA OR [Activity]=MW ;

I have a button called button1
Forms!Form1.Button1

What is the code that I have to attach to button1 to run the query????

Thanks,
AlanA
Ab*********@coned.com

[Wayne Morgan]

What do you want to happen when you "run" the query? If you want to assign
it to the Row Source of the listbox, then the code would be placed in the
button's OnClick event procedure and look something like:

Me.lstNameOfListbox.RowSource = Forms!Form1!Item

Replace Me with Forms!NameOfForm if the code isn't running on the same form
as the listbox.

--
Wayne Morgan
"Alan" <mr**@mindspring.com> wrote in message
news:f8**************************@posting.google.c om...

I created a Multi Select list box.

I even got the code to create the SQL statement in a control called Item.
Forms!Form1!Item

Here is a sample of what appears in Item:
Select Name, activity from Table1 where [activity]=MA OR [Activity]=MW ;

I have a button called button1
Forms!Form1.Button1

What is the code that I have to attach to button1 to run the query????

Thanks,
AlanA
Ab*********@coned.com