Form that creates multiple records...

[sarcastichorse]

Struggling to find a starting point with this task I've set myself.

I'm importing data from SalesForce, and I'm trying to build a form that would auto-populate one of those fields

Field from SalesForce (example, task01)
Start Year (example, 2015)
End Year (example, 2020)


Value (example, 321,000)

And submitting the form creates a number of records in a table, in this example...

task01, 2015, 321,000
task01, 2016, 321,000
task01, 2017, 321,000
task01, 2018, 321,000
task01, 2019, 321,000
task01, 2020, 321,000



Any pointers on how to get started with it would be amazing.

[isladogs]

Run a procedure looping through the years one at a time and in each case running an append query

[June7]

Something like:

For x = Me.tbxStart To Me.tbxEnd
CurrentDb.Execute "INSERT INTO table(Task, TaskYear, Amount) VALUES('" & Me.tbxTask & "', " & x & ", " & Me.tbxAmt & ")"
Next

Value is a reserved word. Should not use reserved words as names for anything.