Saving data from a form to a table

[Guest_imported]

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!

 

[Telsa]

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

 

[Guest_imported]

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

 

[Telsa]

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.