Access - Default Value & Macro

[mulletteeth@yahoo.com]

Does anyone know how I would make the default value identical to
whatever is in the cell directly above? Is there a way in the
Expression Builder? I know I can do this manually by hitting Ctrl +
' If there isn't a way to do it with Express Builder is there a
way I to setup a macro?

[pietlinden@hotmail.com]

Re: Access - Default Value & Macro


mulletteeth@yah oo.com wrote:

Does anyone know how I would make the default value identical to
whatever is in the cell directly above? Is there a way in the
Expression Builder? I know I can do this manually by hitting Ctrl +
' If there isn't a way to do it with Express Builder is there a
way I to setup a macro?

Yes there is...
like this:

http://www.mvps.org/access/forms/frm0012.htm

(I would post the code, but the link it more worthwhile... search
around...)