Inserting form elements into table

[psn]

How to insert form elements into ms access table.

The form is created using design view in ms access.

Where to write code in ms access and do we need any ado connection.

Regards.

[KnooKie]

if by form elements you mean the controls on the form e.g. textboxes, comboboxes etc then you can set the record source of the form to a query and bind each control on the form to a field in the query. It will then update the table in the query automatically.

this is the easiest/quickest way anyhow