Solved

creating query in record source of form compared to creating a query

Posted on 2011-03-20
3
286 Views
Last Modified: 2012-05-11
Hello,
What is difference of creating a regular query and creating on in the record source of form?
also I have 3 subforms on a main form- I read some paper on if you have subform based on query - it is better in the record source- is that true?does it matter? and is there a difference?
thank you
0
Comment
Question by:davetough
3 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 400 total points
ID: 35176250
If you mean comparing using an SQL statement as the RecordSource vs a Saved Query, JET has a better chance of optimizing the Saved Query than an SQL statement.  So, using a Saved Query is probably the better choice.

For a combo/list box, where there are just a few records in the list, based say on a small lookup table ... especially one that does not change often, then I'm not seeing a big difference between using an SQL statement vs a saved query for the Row Source.

mx
0
 
LVL 44

Assisted Solution

by:GRayL
GRayL earned 100 total points
ID: 35176313
I agree with mx, I think you are better off to use the named query as a recordsource rather than typing in the SQL in the recordsource - especially for large complex queries - especially when troubleshooting.  I would far rather modify a query affected by a table design change than go into the design view of the form and try and do it there.
0
 

Author Closing Comment

by:davetough
ID: 35176471
thanks
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question