Yes, what I am saying, is that you know how to perform the action yourself, right?
So hit the Macro "Record" Button (Tools
> Record New Macro
) and do it. Then view the resultant
code generated by Access/Excel for some ideas on how to do it.
I am not saying I dont want to help you, I am tryin to show you one of the best ways to learn how to do this yourself.
The Developing Developer
Currently Working Towards: MCAD C#
My Blog: http://www.robzyc.spaces.live.com
<center>"Nothing can stop the man with the right mental attitude from achieving his goal;
nothing on earth can help the man with the wrong mental attitude".