Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 317
  • Last Modified:

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

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
davetough
Asked:
davetough
2 Solutions
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
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
 
GRayLCommented:
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
 
davetoughAuthor Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now