New to VBA

[mummbles74]

I'm new to Access very new but I am pretty good with VBA. My problem is I have a program that has been given to me to use for data entry at work, it consists of 2 sections one part is for the equipment details and the other for its inspection, the problem I have is that if you make any changes to the equipment data page it clears the inspection page. What I am looking for help about is how I can access the code (like the VBA screen in Excel) so that I can find the code that clears/resets the inspection page.

I know that its a bit vague but I am just looking for a place to start.

Thanks in advance

Mummbles.

 

[RoryA]

Alt+F11 to access the VBE just as in Excel.

 

[mummbles74]

thankyou, I have a stand alone notebook that it runs on and there is a function key to use the F keys.

Now I get Project is unviewable so I am assuming this is the same as having a protected sheet in excel?

So with out the password I am knackered.

 

[RoryA]

Pretty much.