Add data from form to table

  • Thread starter Thread starter Dave
  • Start date Start date
D

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!
 
Dave said:
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.
Click to expand...

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.
 
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!
Click to expand...

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!
 
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
 
Back
Top