Add mulitple records to continuous form

[mru]

I am not sure if this is possible or not but here goes, I am trying to create someway of importing/transfering numerous records (10) into a continuous form, each record has the same basic data of date, payee and amount and will remain the same most of the time, they are monthly Direct Debits and as such will only be entered once a month, i have tried with various attempts using a button on the form and by using a specific key when actually entering other data but can't seem to get any joy. Any tips would be gratefully received.

Thanks

Martin

 

[Remou]

The best bet would probably be an append query. You can either run such a query ten times or use it with a 'template' table.

Very roughly:

Dim db As Database
Set db=CurrentDB

strSQL="INSERT INTO tblSubform (Field1, Field2) VALUES ('" & Me.txtText & "', 123)"
db.Execute strSQL, dbFailOnError