Run macro every time record changes?

[soccerkingpilot]

Hi,
I'm creating a database where a particular tab on the form will only apply to certain people. I've already figured out how to hide/show the tab based on whether or not a particular box is checked for a record, but I don't know how to make this macro run every thime the user looks at a different record. Any access gurus out there have some advice?

Thanks in advance.

 

[CazB]

set it to the 'OnCurrent' event?

 

[soccerkingpilot]

CazB,
I'm new to Access and there's a little bit of a learning curve coming over from Excel. I had tried OnCurrent but it couldn't find my macro...and then I discovered Design View.

Thanks!