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
|
|||
|
|||
Record Souce of a FORM
Helllo all,
Very quick question.... I am building a form with a sub form. Should I build my parent form off of my query (which selects all records from table1) or build my form with a record source table1? David |
#2
|
|||
|
|||
Either way, David
You need to use a query if you wish to select only some fields, limit it to only some records, or specify a sort order. If you don't use a query, Access will probably create a hidden query for you, show all fields, and sort them by primary key. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "David" wrote in message ... Helllo all, Very quick question.... I am building a form with a sub form. Should I build my parent form off of my query (which selects all records from table1) or build my form with a record source table1? David |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Form in Edit Mode | JN | Using Forms | 0 | July 12th, 2004 05:47 PM |
Pop up form doesn't link correctly, PLEASE HELP!!! | Sandra | Using Forms | 4 | June 19th, 2004 01:55 AM |
From a report record to the specific record in a form | Sierras | Using Forms | 1 | June 18th, 2004 02:54 PM |
Can't update table from Form | sara | Using Forms | 3 | June 11th, 2004 02:12 PM |
Form Does Not Go To New Record | Steve | New Users | 1 | May 12th, 2004 03:15 AM |