Add data from form to table

[Dave]

New user, how (what is the code, macro, expression, etc.)
do I add data from a text box on a form to create a new
field in a table. Example: on form I have a place to
input a last name and a "Submit" button, when I click the
button I want the name to be added to the field, then the
field cleared out to enter a new name.

Please Help!

 

[Mike Painter]

New user, how (what is the code, macro, expression, etc.)
do I add data from a text box on a form to create a new
field in a table. Example: on form I have a place to
input a last name and a "Submit" button, when I click the
button I want the name to be added to the field, then the
field cleared out to enter a new name.

Forms are based on tables. There is no need for a submit button, simply fill
in the information and move to a new record.
There is a new record button on the menu bar and at the bottom of the form.
You can also use a wizard to add a new record button.

I rarely do this because the more my users know about Access, the less they
use me.

 

[John Vinson]

New user, how (what is the code, macro, expression, etc.)
do I add data from a text box on a form to create a new
field in a table. Example: on form I have a place to
input a last name and a "Submit" button, when I click the
button I want the name to be added to the field, then the
field cleared out to enter a new name.

Please Help!

You're misunderstanding how forms work!

By default, a Form based on a table lets you add data. No button, no
code, no special effort required - just use the *> arrow to move to
the blank "new record", and start typing. When you're done, move to a
new "new record" and the data you've entered will be written to the
table.

In other words - don't make it difficult when it's already easy!

 

[Katrina]

is your form bound to the table that you want to insert the value into? If
so, on submit save the record and go to a new record.
if not add the entered value to the desired table, then set the value of
the LastName field to ""

HTH
Kat