Bascially what I want to do is this. On a Membership form I have a drop down list that puts companies in their membership catagory. If you select the catagory of Former Member the form changes color to lets say red but all the other member records stay the same. Any Help???

Add a little code you your form.

First in the AfterUpdate event of your combo:

If Me.ComboNameOfMemberCategory = "Former Member" Then

Me.Backcolor = 255
Else
End If

Also, on the OnCurrentEvent of the form:

If Me.ComboNameOfMemberCategory = "Former Member" Then

Me.Backcolor = 255
Else

Me.Backcolor = 111

End If

The "Former Member" should be the actual value of the control when "Former Member" is selected.

Hope that helps you out!

I suspect jwindon meant to add a line like
Me.BackColor = 111
on the line immediately after his first 'Else' statement.

Thanks to both replies.