INSERT statement

[GraeagleBill]

I have a simple table that I want to initialize. However, I get an error message "Too few paramaters. Expected 1." with the following code. I'm expecting the remaining table fields to simply default according to their field attributes. FIELDS: "RoomNumber" plus One autonumber field, one number field and four text fields.

Private Sub InitRooms()
Dim I As Integer

For I = 1 To 1000
CurrentDb.Execute "INSERT INTO tblRooms (RoomNumber) VALUES (I);"
Next I

End Sub

What am I missing here?
Thanks,
Bill

[June7]

Must concatenate variable otherwise the value trying to save is the literal alpha character 'I';

CurrentDb.Execute "INSERT INTO tblRooms (RoomNumber) VALUES (" & I & ");"

[GraeagleBill]

Ah yes! I see.
Thanks,
Bill