Docmd.Outputto Help

I am trying to output the result of a query to an excel worksheet. But I
want only the filtered data to go to the sheet. Records are filtered based
on the user input on a form. The command I am giving is as follows:

DoCmd.OutputTo acQuery, "Get_country_Info", "MicrosoftExcel(*.xls)", "C:\Documents and Settings\sagarwal\My Documents\Database\test.xls", True, ""

where "Get_Country_Info" is a predefined query.
It gives me the details of all the countries but I only want the countries which the user selects from the list box in the form

Is there a way I can write the query itself in the OutputTo command? I tried to substitute the query itself instead of passing the query object as follows:

DoCmd.OutputTo acQuery, "select country_name from country where country_name in ( " & tempcountry ")", "MicrosoftExcel(*.xls)", "C:\Documents and Settings\sagarwal\My Documents\Database\test.xls", True, ""

where tempcountry is a list of selected countries by the user. But it gives me an error saying
"database engine could not recognize the oblect 'select country_name from country where country = 'USA'' "

Any ideas??? Thanks in advance.

Check out this link. This is a solution to your problem but it does not use the Docmd.

http://www.microsoft-accesssolutions.co.uk/query_using_listbox.htm

John

Thanks a lot. That is exactly what I was looking for. Appreciate your help

Regards,
GreetInfo