Hi all,
I'm a pretty new with this so please help with patience.
I have a Query in Access that need to export to Excel. I usually use DoCmd.TransferSpreadsheet or DoCmd.OutputTo to do this and it works fine. Now, I want to output this Qry_file to Excel but in selected Group field. The user can select the group, from a combo box that list all the group number, then click the button and have the spreadsheet filtered by their selected group.
If you're not clear or have any question, please ask.
Thank you in advanced!

You want the user to use the same query you are already outputting? If so, on the On Click button to run your function, do this:

Dim sGroup, sLink, sDoc As String

sGroup = Me.GroupFieldName
sLink = "[GroupFieldName] = '" & sGroup & "'"
sDoc = "qryYourQueryName"

DoCmd.OpenQuery sDoc, , sLink

DoCmd.TransferSpreadsheet etc.

DoCmd.Close acQuery, sDoc

Something like that.

Does that help?


mmcdonal