There are lots of good sites that offer excellent advice on creating
procedures (macros if you like) in vba with Access. I think a good place to
start is http://www.mvps.org. For your own interest, you may like to try
using the Macro builder in Access then coverting those macros into vba code
(In Access 2000 :Tools-->Macros-->Convert Macros to Visual Basic). This
will enable you to see how Access configures vba code.