If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Export Data from Subform
On Fri, 18 Jun 2004 13:30:00 -0400, "Antonio"
wrote: Hello everybody...how do I programmatically transfer data from a subform that feeds from a query? It's not linked to a table. Thanks, Tony What *IS* the subform linked to? You can't have a multirecord subform unless it is linked to a table, perhaps via a query. What is this subform's Recordsource property? What information is on the subform that you wish to transfer? John W. Vinson[MVP] Come for live chats every Tuesday and Thursday http://go.compuserve.com/msdevapps?loc=us&access=public |
#2
|
|||
|
|||
Export Data from Subform
On Mon, 21 Jun 2004 08:27:38 -0400, "Antonio"
wrote: John, the RecordSource property is a query. The subform displays the results of a search. Example: I have a search form from which you can find out how many customers subscribe to a particular book title. So, you select the title in question and the query finds all the customers subscribing to this title and displays the results in a subform. Now, this subform is not bound to a table, but to a query. But the Query *IS BASED ON A TABLE*, or perhaps more than one table. Data cannot exist in a vacuum - it exists in Tables, and it exists nowhere else. I would suggest simply exporting the data *from the query* that you're using as the recordsource of the subform. John W. Vinson[MVP] Come for live chats every Tuesday and Thursday http://go.compuserve.com/msdevapps?loc=us&access=public |
Thread Tools | |
Display Modes | |
|
|