Move data from textbox to table

[113deluxe]

I have a form with 5 text boxes, how do I transfer the data that are typed in the textbox into a table, each textbox represents a field in the table. I want to create one new record everytime the user types in data and registers on the click of the button.

How do I do this??
I`m a real newbie to access so please be patient with me

 

[Fizzio]

You need to 'bind' the table to the form initially. In the design mode of the form, select the properties of the form (click on grey square top left of form) and set the recordsource to the table you are wishing to store data in.

Select each textbox in turn as set the controlsource of the textbox to the name of the field you want to store the data in.

Have a look at the MS examples packaged with access to get a good idea where to start.

 

[113deluxe]

Thanks...It worked like a charm