create new record in other table

[lockstock]

hi,



I need some help with vba

When a button is clicked in a form I need to create a new record in a table, not displayed in the form, and the value of one column needs to be equal to the ID of the record shown in the current form.

anyone who can help?

thanks!

ben

[ranman256]

no vba needed, create an append query to add a record.

[lockstock]

okey i will give it a try thanks