I have created an report through front end using an combo Box and an command button , "It Wroks". Now i want to run an query through front end similarlly by using combo box and command button and export the resulted data to excel sheet . But when i give the VB
Docmd.OperQuery "QueryName" , ............."
I am geting the whole query running and whole data in the database, instead of getting the selected Names data and what is the command for exporting the data to excel?
Weather i am able to get the data by runcommand option or by other
Pls help me in this issue so that my head ill lose some weight.
thanks in advance from my deep heart...:)