I know it can be done in Excel, but I have no idea how to do it in
Access. A lot of the behavior I want is to have the user select a cell
in a recordset, choose a custom menu item, and have my macro perform an
action using the value in the cell clicked.

Is this possible? Any help would be most appreciated.

You can set the right click menu in the "other" tab. It is the "short cut"
menu option.

Thus, you simply build a custom menu with some options that calls your code.
The building of menus in ms-access does not take code, and you use drag and
drop to do this. These menus you build will thus call your custom code to do
whatever you want.

If you need to do this in a datasheet type view..I would use a continues
form.
You likely can, (and should) use a continues form, as get a low more
control. Continues forms look like datasheets.

Here is a few examples of continues forms:
http://www.attcanada.net/~kallal.msn/Articles/Grid.htm


And, here is some info on making menus in ms-access:
http://www.microsoft.com/Accessdev/a...ers/ba01_6.htm


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
(E-Mail Removed)
http://www.attcanada.net/~kallal.msn