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.
