Updating tables with a whole record

[red7]

HI,

I need a macro to run once a 'confirm' button is pressed in one of my forms. I need the macro to send the current record I have added in my form to a table, which will store all of the day's takings.

I have been unable to find a macro that updates a table with a whole record.

Please help even if it is stupidly easy

Thanks in advance

 

[Smilie]

If you really want to append a record to a specific table only when you click a button then you could do this with a macro that has an OpenQuery command. The query should be an append query, not an update.

However, I am wondering if you are actually wanting to put this record in one table or two tables? Because it would automatically go into whatever table your form is bound to, assuming you have a bound form.

Hope that helps?!?