Changing BackColor in Subform

M

Michelle Wilson

Hello,

I have a main form called frmSales and a sub form called
subfrmContact. I need to use the subfrmContact in many
other main forms but the backColor needs to be different
and I do not want to recreate it.

How do I reference the backcolor in the subform? I have
tried the following but the syntax is incorrect.

[Forms]![frmSales]![subfrmContact].Form![Detail].BackColor

Thank you,

Michelle
 
D

Dirk Goldgar

Michelle Wilson said:
Hello,

I have a main form called frmSales and a sub form called
subfrmContact. I need to use the subfrmContact in many
other main forms but the backColor needs to be different
and I do not want to recreate it.

How do I reference the backcolor in the subform? I have
tried the following but the syntax is incorrect.

[Forms]![frmSales]![subfrmContact].Form![Detail].BackColor

Thank you,

Michelle

Try:

Forms!frmSales!subfrmContact.Form.Section(acDetail).BackColor
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top