Spreadsheet-like edit view?

[Johan Myrberger]

Hi,

I have a table with three fields; Customer, Month and Sales. This will
allow me to enter single records as I go...

For "batch" input I'd like to create an input form in a spreadsheet-like
way; Customers listed on One axis, Month on the other and then enter the
Sales in the matrix.

How can I achieve this?

regards
/Johan Myrberger

 

[Duane Hookom]

Do you know how to write and maintain code?

 

[Johan Myrberger]

Sounds like this type of view is not an out-of-the-box experience...

Well, I am a bit rusty but have been coding before... Any pointers to
examples etc woudl be appreciated.

regards
/Johan Myrberger

 

[Duane Hookom]

I would probably create an unbound form with controls forming a grid
appearance. A recordset would "gather" the values and place them in the
controls. When the user clicks a button on the form, code would loop through
the unbound controls and write the values back to the table.