datasheet form updating

[Guest]

I have a table bound to a form in the "datasheet" format.
I need the ability for a user to:
*enter as an example $50.00 in the first "cell".
*then select any number of rows beneath it.
*then some type of keystroke, maybe hitting "ENTER" KEY will execute code
to autofill these rows with $50.00

this is similar to the dragdown copy feature in Excel.

Heres how it looks.

--User enters 50.00 in a cell.
Jan 50.00
Feb
Mar
Apr
may
June
July
Aug
Sept

-then user selects as an example Apri thru June in datasheet form
Jan 50.00
Feb
Mar
Apr User selects this row
may and this row
June
July
Aug
Sept

 

[Douglas J. Steele]

It can't be done.

You'd be well advised to realize that while the datasheet format may look
like a spreadsheet, it isn't one, and you shouldn't expect techniques that
worked in Excel to work in Access. The appropriate way to update a number of
rows is with a query.