Just Curious... 3

[2176]

Which way is better I've been told both ways, but never from someone who does this for a living. For just a simple database should you base your forms from the tables, or create queries and base them from the queries? Does either way help run-time? Just curious...

 

[BanditWk]

Depending on the type of form, in all actuality.

If it's a DataEntry form, there is no need for any underlying queries, only direct access to the Table.

If it's a View/Modify type of form and you're wanting to look at specific record(s), you can have the form linked to the table, but have a drop-down run SQL that would limit the current record views.

HTH!
Roy McCafferty
aka BanditWk

Las Vegas, NV
roy@cccamerica.org
RLMBandit@aol.com (private)

"No need to send gifts, I do this for the votes!"

 

[2176]

Thankyou, for answering my questions so quickly, I thought the same, but sometimes there are those that know everything. I think you deserve a...

 

[LittleSmudge]

For forms that are bound to one single table then a query is unnecessary. You can view selected records within the table's dataset by using the WHERE clause in the DoCmd.OpenForm

For tables that are bound to multiple Joined tables :-
Unless you are going to 'reuse' the query ( that is - have many forms bound to the SAME query ) then there is no need to have queries discretely stored in the database's query window.
You can place the SQL string directly into the Form's Record Source.
You can also apply the DoCmd.OpenForm's Where clause selection to this approach as well.



'ope-that-'elps.




G LS
accessaceNOJUNK@valleyalley.co.uk
Remove the NOJUNK to use.

Please remember to give helpful posts the stars they deserve!
This makes the post more visible to others in need! :-D