Entering data to a form in access

[Nats]

I created a form a little while ago, how I have recently added a couple of columns to the table that the form gets its information from.

The only thing is it will be a lot of hard work to re- create a new form - from my table, so I what I need to do is go into design view and add two more text boxes so that will update the 2 columns I have added in my table.

But does anyone know how I set it so that the text boxes in the form, know which columns they represent in my table.

Thank you in advance for your help.

 

[Alc]

Once you've created your new fields and placed them where you want:

1) Right-click on one of the fields and choose 'Properties'.
2) On the 'Data' tab, go to 'Control Source'.
3) There should be a small arrow to the right of this field.
4) Scroll down through the values in the displayed list and pick the field you want.
5) Repeat 1 - 4 for the other field.

 

[mattkorguk]

Hi,
The 'Control Source' of the new text boxes just needs to be the same as the new fields on your table. If the form is built using a query, ensure that these new table fields are also added to the query before adding them to the form.

Matt

 

[neileg]

Or, if its a simple text box you need, simply drag the new fields from the field list and drop them on the form.