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