im still not sure where the 300 items are.
if you have 1 query with 300 different keys where the keys are the value of the combo box
Below is run with an 'export' button:
Code:
sub btnExport_click()
dim vID, vFile
dim i as integer
for i = 0 to me.Grp_Selector.listcount-1
vID= Grp_Selector.itemdata(i) 'get next item
Grp_Selector = vID 'set the cbo to this item
'export the query shown
vFile = "C:\folder\" & vID & ".xls"
docmd.TransferSpreadsheet acExport ,acSpreadsheetTypeExcel12 ,"Hotel_T Query",vFile,true
next