New Record on button click.

I have a number of fields on a form. On a Command Button click I need to be able to add the info from the fields to an existing table as a new record.

For example:
Take the info from Text1 & Text2 and put it as new record in the table called 'tblTime' under the fields 'Start' (for text1) and 'Finish' (for text2).

I don't really want to have to see the table at time of input, Just pass the values in as a new record.

Any assistance would be much appreciated.

Regards
Colin

URL

Read about the INSERT statement.