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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.