Re: Export subform to Excel

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: PC Data*** (spam_at_nospam.spam)
Date: 02/25/04 

Date: Wed, 25 Feb 2004 14:02:09 GMT

Create a query based on the recordsource of the subform. Set the primary key
criteria in the query to the value on the subform. ie,
Forms!Name)fMainForm!NameOfSubform!NameOfPrimaryKeyTextBox. 

--
                                         PC Data***
Your Resource For Help With Access, Excel And Word Applications
                              resource@pcdata***.com
                                 www.pcdata***.com
"Charles D Clayton Jr" <charles.clayton@kos.kiewit.com> wrote in message
news:47f3e165.0402250546.30da2586@posting.google.com...
> A2K
> I have a mainform with tabsheets on it.  I have added a subform that
> changes its recordsource depending on which tab is pressed.  The
> subform shows its information in a data*** view.  I was able to add
> a combo box to sort the data for the user.  What I am having a hard
> time doing is figuring out how to take whatever data is in the subform
> and send it to Excel.  Everytime I do it, it sends the whole table
> instead of whatever information is on the subform.  Does anybody have
> any bit of code to help?
>
> Thanks,
>
> Charles D Clayton Jr
Quantcast