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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append only Null records in table 2
Search utility 2
append query not appending 2
Appending records to new table using field names as values 2
Append Queries in 2007 5
Append Query 3
Skip Records on a Form 2
Can new columns be added to appended table records, how? 3

Top