Recommended way to enter via grid?

[Laurel]

I want to make a user interface consisting of 7 rows (tblScores). Here are
the ways I've thought to do it, but it seems like one of those things that
is done so often that there's a best way. Is there? (the main obstacle in
my case is that edit checks prevent the saving of empty rows to disk and
Access insists on doing a save of one row the minute I move to a new row....
I think that's what it's doing.)

1) Set my form at read only, and then insert each row via code. Presumably
the rows would insert but not save as the next one was inserted, thus
avoiding integrity violations. Not sure this will work. Set it to
writeable after empty rows are created.

2) Make a table that looks exactly like tblScores but with no edit checks
tblScoreTemplate. It would contain 7 rows, with key values of 1 through 7.
Retrieve those rows each time the interface needs to be refreshed, and
populate the key column with appropriate values. When the user is done,
move the new rows into the real tblScores and refresh tblScoreTemplate with
new empty rows.

Does anyone have anything more straightforward to suggest?

 

[Duane Hookom]

Without know more about your constraints, I would consider using 2). However
you might also be able to use an unbound form with a "matrix" of text boxes
in place of the "tblScoreTemplate".