Data in forms to Tables

[coolpal9]

Hi,

I have a database with 6 forms all interconnected with buttons.



I want that when the forms are filled up, the same data should be duplicated simultaneously in the tables also.

How can I go about it?

Pl help..!

[June7]

You should bind the forms to tables and bind data controls (textboxes, comboboxes, listboxes) to fields. This means setting the form's RecordSource property and control's ControlSource property. This is basic Access functionality and guidelines for building bound forms are available in Access Help. With bound forms and controls, entries to controls are entered directly to fields of the bound table. The data is committed to table when the form closes, move to another record, or by code saving record.

Saving data to table from unbound form requires a lot of VBA code.

[coolpal9]

Bind as in? Do what?

[alansidman]

Typically in access, you will build your tables first. Then you will create your forms using the tables as a record source. When you start to build your form you will link (or in Access terms Bind) the form and controls (text boxes on your form) to a table. If this is not what you have done, then you will need to update your tables via VBA as June has indicated. Much more complicated but it can be accomplished. Here is a tutorial on how to do that.

http://www.datapigtechnologies.com/f...rdsnocode.html

Alan

[June7]

Bind means set form RecordSource property to a table or query and set control ControlSource property to field. Search the Access Help on topic: create form