The first screenshot is what I have now on multiple forms. The second screenshot is the global module I created. The third is the error I get when running this module. And the last is how I inserted the module command in my form event.

Yea you can't just use "me". It doesn't know what me is. Your going to have to send a form name to the sub as well as a parameter and then use that to set the colors.

Unless you have a "Male" field on every one of these forms that you use this on, you can't use that either and would need to provide a parameter for that too.

So you would need to do like
Public Sub MySub(MyForm As Form)
MyForm.Detail

Then you would need to call it with something like
MySub(Me.Name)

So can you explain this a little more? Do I have to make a module for each form? Only changing the form name in each module? Also I have male field on each of the forms I am using this on. I sorry it is not making sense to me.

Richard, sit tight. I've got a video on ActiveForm coming out. You can use that. Hang in there for a bit...

The Global function does not know what "ME" refers to. Me only works when you are in the form or report itself.
you need to do one of two things:
1) send the form to the Global function as an argument
2) give the full name of the form as in (Forms!MyFormF!MyField.BackColor)

I was too slow again. lol

And of course, ActiveForm doesn't work with this situation. I'll explain why in the video... but yes, the guys are right... passing the form to the global function works well. Video coming up...

I tried ActiveForm first and the Main Menu changed colour instead. LOL.

Richard start with this: Passing a Form

This video works great except with my last ElseIf Statement. I changed ELSEIF ISNULL F ("Male) Then to ELSEIF F("Male")<>0 OR -1 THEN and it works. When I ran Compile I got an expected Then Error. But Thanks For all the Help guys!