thanks alot Scorp this really did help; i guess i will have to invent some type of Event to make my teacher happy "he wants to see a code" embeded macros are not enough!

Thanks alot

I am using Access 2007; i will try your answer now

Is there any way i can view the VB code of all the objects i created in my MS Access Database?; in the Event Procedure of any object; it only shows me the events; not the actual design?

p.s. i created the DB using wizards

You see i created this MS Access Database (assignment) using wizards to create all my Tables; Forms; Queries and Reports ; now my teacher is asking for the VB code (the object design code); i can get...