how can i have info on a form save to a table?

A

access_rookie

i'm new at access however i've created a form that's suppose to allow the
user to input info and have it save to the tables that i created, however i
don't know how to make the connection so that when the user type in their
info on the form it would save to the tables. if someone could plz help me
out with this i would really appreciate it. thanks a bundle
 
M

Marshall Barton

access_rookie said:
i'm new at access however i've created a form that's suppose to allow the
user to input info and have it save to the tables that i created, however i
don't know how to make the connection so that when the user type in their
info on the form it would save to the tables. if someone could plz help me
out with this i would really appreciate it. thanks a bundle


You probably need to get a beginners book on Access. The
idea of using a form to interact with data in a table is a
very fundamental concept called bound forms. The table (or
a query) can be specified in the form's Record Source
Property (open the form's property sheet from the View
menu).

Many types of controls (most commonly text boxes) on a form
can be bound to a specific field in the form's record source
table/query. This is done by specifying the field name in
the control's Control Source property. This can be most
easily done by displaying the form's Field List window (View
menu) and dragging the field from the list to the form.

You may be able to at least get started by using a form
Wizard to initially create a form and letting it fill in
most of the details for you.
 

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

Top