I want to process data entered into an Access 2007 form and then append the data to a table within the database.

I started with a simple form with a button running a macro which ran an APPEND query, and this was fine until we needed to add some conditional fields on the form (e.g. if this box is ticked, then double the value that was entered in this textbox, etc).

I thought there would be a simple way for a Visual Basic script to read in all the values from the form, process them, and then append the data to the table.

I have searched and searched, but can't find anything close. Can anyone here help? I can get my head around VB, I just don't know how to use it to talk to tables in Access.

Many thanks,