datasheet fill color changes

[trevor40]

Hi, I'm trying to change the fill color for a datasheet subform and it's not working. If I open the form normally I can change the fill color using the menu.

My questions are -
Can i change the fill color of the datasheet in single form mode using VBA
Can I also change this using VBA if it's a subform datasheet

My problem is the system I am developing is for 2 companies in the same office, each with thier own colors, the customers form is currently on a tab page (in datasheet view) with all employees listed, I will use a combo box to select the company and list only employees for that company, but would also like to change the fill color as well. If I have to I can use a standalone form on top of the tabed menu system I have.
I am doing this so it's obvious which company is selected throughout the tabed menu system

[June7]

This worked for me:

Private Sub Detail_Paint()
Me.Detail.BackColor = vbRed
End Sub

Probably want to set AlternateBackColor to No Color.

[trevor40]

thaks for that, I did find Me.Detail.BackColor, and I just worked it out -
Me.Employees1.Form.DatasheetBackColor = DLookup("[form color]", "[application data]", " [company title] = forms![main menu]![combo1290] ")
will change the datasheet backcolor for a subform datasheet view

Thanks for you help