datasheet form updating

  • Thread starter Thread starter Guest
  • Start date Start date
G

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