Automatically adding multiple records to a table.

[alcapps]

yes.. june7 answered you question..



if you want to do the query method on the button click you can do docmd.openquery "query1" instead of the sub procedure call.

just copy the module over into your db and rename the items to match your tables.

Good luck..

[Roadbeer]

Thanks again to both of you. Now to move on to my next frustrating adventure