doCmd.TransferSpreadSheet query with parameters?
Posted on 2003-11-17
Hi I have a VB form that allows the user to choose the name of a company from a drop down list. I want to use the selected value of the drop downl list as an input to a access query. The results of this query I want to export to excel using the doCmd.TransferSpreadSheet command. DoCmd.TSS allows u to give it the name of a table or the name of a Select query, but how do I make sure my query's input parameter gets included.
my query looks like
"Select * from Companies where ID=[x]"
I need to input the value of x into the query before I do the TSS, any ideas?