A form does NOT have any data until it is bound to a form -- either in
design view or programatically. A form is merely a user interface that
allows you to display the data from a table or tables.
I'm quite baffled as to what would be the point of an unbound subform, but
you can always use Automation to open an instance of Excel and
programmatically transfer individual data items from your Access form to the
Excel spreadsheet.
