View Single Post
  #23  
Old January 14th, 2009, 12:03 AM posted to microsoft.public.access.forms
David W. Fenton
external usenet poster
 
Posts: 3,373
Default Data entry into table field.

strive4peace wrote in
:

one reason I tell others to use tables is to keep them from
creating a recordset that cannot be updated


Can you explain what you mean by that? First off, in a combo box,
it's not relevant. Secondly, in a form's recordsource, you end up
with the most inefficient data retrieval possible. There is no
possible way that this recordsource/rowsource:

MyTable

will behave any differently in regards to editability than:

SELECT MyTable.* FROM MyTable

They are exactly equivalent. And the latter is always, in my
opinion, superior.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/