Saving data from a form to a table
Saving data from a form to a table
(OP)
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.
thanks!
thanks!
Are you a
Computer / IT professional?
Join Tek-Tips Forums!
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.
Talk To Other Members
RE: Saving data from a form to a table
RE: Saving data from a form to a table
RE: Saving data from a form to a table
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.