VBA is much preferred over macro's; best way would be to get a book on the subject. I have Sams "Teach Yourself Access 2002 Programming" which is a good introduction. Once you have started, and know the basics, you will find it much easier to find answers to your questions in this forum, rather...