Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Saving data from a form to a table

Saving data from a form to a table

Saving data from a form to a table

Hi, I'm just beginning so bear with me...I'm wondering how I get data from the form I created into an existing table I have.


RE: Saving data from a form to a table

What table is the form attached to when you created it?

RE: Saving data from a form to a table

none...perhaps that's the problem?  can I do it after the fact?

RE: Saving data from a form to a table

Yes, you can add the table to the form.  

Create a table (if you haven't already) that has matching field names of the form.  

Then with the form in design mode, click on the upper, left corner of it and then select the properties button.  There you will find a field for Record-Source.  Click the drop down button and select the table you want.  

You will have to go to each field and associate it with the name of the field in the table so the data will populate the record.

You should always create a table to store data before you create the form.  Then when you create the form, you can immediately link the table and the fields will show up available for placing on the form.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close