Forms and Queries

[TeeSee]

Is there a "rule of thumb", "best practice" andor "pros and cons" to
basing a form on a query or directly to the underlying table??

 

[Dale Fye]

I generally use a query, to ensure that the records show up in the same sort
order every time. And I save the query as something like:

qry_frm_SomeName_frm

I name the queries for the controls on a form in a similar manner:

qry_frm_SomeName_cbo_Department

This ensures that all the queries beloning to a particular form show up
together in my database window (navigation pane), and that I can quickly
identify the query that belongs to each control. The other advantage of
saving the queries is that they get compiled, and run faster than if you
don't actually save the query.

--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.