Populate table with new records based on first value entered. VBA Access

[zoeb]

Hi,

I'm very new to writing databases using VBA and I'm sure this is relatively simple to solve.

I have a table called tblYear and the user enters a value of a year from a form e.g. 2003. I would then like the table to populate with the years for the next 5, each with a new user I.D. on button press for example.

e.g.
ID Year
1 2003
2 2004
3 2005
4 2006
5 2007

I'm guessing with a for loop stepping through values of i, but I simply don't know how to write this.

Any help would be GREATLY appreciated.

Zoe

[nico5038]

Not sure what you mean with the userid and the ID of the tblYear.
For inserting data you can use code like:

Dim intI as Integer
for intI = 0 to 4
   currentdb.execute("INSERT INTO tblYear (Year) VALUES(" & Me.txtYear + intI & ")")
next
 

Nic;o)