FastLearnerIThink
Technical User
I have a form with two combo boxes, a subform, and 3 command buttons. cbo1 is to select which report, cb2 selects sort type. cmd1 is to view results in subform, cmd 2 is to view access report, and cmd3 is to export to excel.
When clicking on cmd3, FileDialog opens for user to select the default blank form. blank form gets filled with applicable data, then user is given the option to save a copy. Instead of having the user type in a filename, I would like the save as filename in the FileDialog to be filled in with the default filename given to it through VBA.
How can I accomplish this with the code provided by rajeessh in thread702-276412? Please let me know if further info is reuired. Thanks.
-- Fast Learner, I Think
Here's something to think about. How come you never see a headline like 'Psychic Wins Lottery!'? - Jay Leno
When clicking on cmd3, FileDialog opens for user to select the default blank form. blank form gets filled with applicable data, then user is given the option to save a copy. Instead of having the user type in a filename, I would like the save as filename in the FileDialog to be filled in with the default filename given to it through VBA.
How can I accomplish this with the code provided by rajeessh in thread702-276412? Please let me know if further info is reuired. Thanks.
-- Fast Learner, I Think
Here's something to think about. How come you never see a headline like 'Psychic Wins Lottery!'? - Jay Leno
