Spreadsheet-like edit view?

  • Thread starter Thread starter Johan Myrberger
  • Start date Start date
J

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
 
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
 
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.
 
Back
Top