change forecolor of form when got focus 1

[fredk]

I have a form with a sub-form - how do I make the background color different for the form that has focus?

I realize I probably need to use the got "on got focus" and "on lost focus" but I am having a hard time figuring out the code ?

Any help would be greatly appreciated!!!

Thanks!!

Fred

 

[addy]

In your GotFocus Event you need something like:

Forms!MyFormName.Section(0).BackColor = MyColour

Rename MyFormName to the name of your form and MyColour to the colour you want and it should work I believe.

 

[fredk]

I tried it but it is not working - I have:

Forms!frmgroups.Section(0).BackColor = 255

I tried to change the section number also - it is the detail section I am trying to change.

Thanks!!

Fred

 

[Eupher]

Hi, Fred:

Here's a good link for form/subform referencing:

http://www.mvps.org/access/forms/frm0031.htm

Also, if you don't want to use the numerical index for the section on which you're changing the backcolor, you can refer to it by name:

Forms!MyFormName.Section([blue]"Detail"[/blue]).BackColor

HTH,

Ken S.

 

[fredk]

Perfect - thanks Ken!!!!

Fred