Export Current Record (Only) to Excel

[JoshuaAnthony]

Hi,

I know that I can use DoCmd.OutputTo in order to export form data t
excel spreadsheets but I'd like to only export data for the CURREN
record if at all possible. The form that data is exported from coul
be based on a number of different queries (depending on user-selecte
search options) so I'd prefer to avoid making yet more queries for eac
option if possible!

Thanks,

Joshu

 

[JoshuaAnthony]

Decided just to use an extra form simply for the purpose of filterin
only the current form and then calling DoCmd.OutputTo on that form