View Single Post
  #21  
Old January 13th, 2009, 11:58 PM posted to microsoft.public.access.forms
David W. Fenton
external usenet poster
 
Posts: 3,373
Default Data entry into table field.

John W. Vinson wrote in
:

On Mon, 12 Jan 2009 19:15:00 -0800, FBrnstrmr
wrote:

rowsource,


A Query from which a Combo Box or Listbox gets its data from.


Or a SQL statement. Or a table name. Or a query name.

[]

and
recordsource.


A Query which provides the data for a Form.


Or a SQL statement. Or a table name. Or a query name.

In both cases, it's actually not advisable to use just a table name
as your rowsource/recordsource. It's always better to use a saved
query or a SQL statement, even if that SQL statement is only:

SELECT MyTable.* FROM MyTable

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