datasheet form updating


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
 
Ad

Advertisements

D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top