Data entry from spreadsheet type form 1

[SMHSleepy]

Hello all,

I have tblPayroll with fields Name, WorkDate, Hours.
I'd like to have a form in a spreadsheet type view with WorkDate as column headers and employees on the left as row names. Something like this:

Jan1 Jan2 Jan3 Jan4 Jan5 Jan6 Jan7
John S.
Jane D.
Bob S.

Then the user can enter the hours for each employee on their respective work dates. i.e.:

Jan1 Jan2 Jan3 Jan4 Jan5 Jan6 Jan7
John S. 8 12
Jane D. 5 8
Bob S. 8 8

tblPayroll should then look like this:

John S. Jan1 8
John S. Jan2 12
Jane D. Jan3 5
Jane D. Jan4 8
Bob S. Jan5 8
Bob S. Jan6 8

Sorry if my example columns don't match up on your screen, but you get the idea.

Any suggestions? Thanks.

 

[SMHSleepy]

Perfect!
Well, one more small thing I just noticed. If I put an entry into the top left corner of the grid, close the form, then open it again, it shows the cell as greyed out but doesn't show the code. If I click any other cell, then the code appears. Like I said, not a big deal but it may confuse one of the users. Any thoughts as to why that happens?

 

[MajP]

Never seen it happen, but it may be a focus issue where that cell has the focus since it is the first control that is enabled. You may be able to have a an unbound control and set the size to (0x0) basically making it invisible. Make that the first control in the tab order or set the focus when the subform loads.