Append one record into a table from form fields

C

Crown Jenny

Can one record be appended from form fields into a table to create a new
record?
If so, need detail since I am new to this.
 
P

Pat Hartman

If you use a bound form, you don't need any code. Access handles saving
records for you. For a form to be bound, it needs a table or preferably a
query name or SQL string in its RecordSource property. Then individual
controls on the form would be bound to columns from that RecordSource by
selecting a field name as each control's ControlSource.
 
T

Tom van Stiphout

On Fri, 28 Dec 2007 12:39:03 -0800, Crown Jenny

Check out the Northwind sample application - any form. It allows for
adding records without a single line of code.

-Tom.
 
Top