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
|
|||
|
|||
Use results from query on a form
This is probably something simple but I am trying to figure out how to take
the datasheet results from a query and copy that information onto a datasheet on my form. Help please!! -- jrusch |
#2
|
|||
|
|||
"jrusch" wrote:
This is probably something simple but I am trying to figure out how to take the datasheet results from a query and copy that information onto a datasheet on my form. Help please!! -- jrusch You don't - you can't. Tables and queries (virtual tables) store data. Forms are views into the tables/queries. Create a new form in datasheet view using the wizard, selecting the query as the record source. To use a current form, in design view, open the properties window and change FORMS/DEFAULT VIEW to DATASHEET. That is all it takes. HTH Steve -------------------------------- "Veni, Vidi, Velcro" (I came; I saw; I stuck around.) sanfu at techie dot com |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How can I show data in a form | Nick Coe \(UK\) | Using Forms | 6 | September 20th, 2004 08:55 AM |
Display Parameter from Form on Report | sara | Setting Up & Running Reports | 10 | July 19th, 2004 04:54 PM |
Newbie? Do I use Report or Query | John Egan | New Users | 11 | June 28th, 2004 08:31 PM |
Query Form: Print Report | Dennis | Running & Setting Up Queries | 1 | June 6th, 2004 01:08 PM |
sort query results for a form | Jeff Lane | Setting Up & Running Reports | 1 | May 30th, 2004 07:33 AM |