Reference a Bound Combo Box In Report Through VBA

Originally Posted by icenemesis

Hello,

I am using Access 2000.

I have a combo box that is bound to a query that lists the status' from the following table.

Status Table
---------------------------------
id name
---------------------------------
1 Identified
2 Development
3 Owner Review
4 Approver Review
5 Signed Off

the combo box shows the name and is bound by the id.

In the report I am creating I want to set a rectangle backcolor to a specific color depending on what status the certain record is.

So if status is 1, backcolor = yellow, etc

I can set the back color easily enough, but I cannot figure out how to check which status is in the combo for the life of me. The Text or Value property aren't there, etc. I am fairly knowledgable with Access and VBA but I cannot wrap my head around this. Any ideas?

Originally Posted by icenemesis

My idea didn't work , but it wouldnt matter if it did because conditional formatting only allows 3 formats when I need upwards of 5.

Anyways what I was going to try to do is put the status field in behind the id and name and kind of turn it into the rectangle in a sense. Change its text color and background to be the same color with conditional formatting but that proved not to work. For what reason.. I'm not sure, but like I said the 3 formats would prove to be a problem.

Alright, well see how I can do at trying to explain this again.

Each id and name has a status associated with it. I want a rectangle behind the id and name that will change its color on report load depending on what the status associated with that id and name is.

-----------------------------
| 100-100-100 Name |
-----------------------------

It would look something like that but would be say... Yellow if status is identified, blue if status is development, etc.

I appologize. I lied in that last reply. The report is based off of a table which has id name and status. And status in that table is a lookup to the status table which included the id and name for each status which is:

1 Identified
2 Development
3 Owner Review
4 Approver Review
5 Signed Off

It's been a long day and my brain is some what mush...

Anyways, so what I was thinking of doing was going into VBA and using the On Open event. and in there somehow check to see what status is for each row that would be shown in the report and set teh rectangle backcolor according to that.

Private Sub Report_Open(Cancel As Integer)

' do the check in here.

End Sub

I might be thinking about that all wrong and there might be an easier way to do this. ANyways, thats my explaination hope this one helped out a bit more than the last two.

Originally Posted by icenemesis

That looks to be exactly what I need. And it worked perfectly! Thanks a ton for your help!

So how does that on format work?
Does it get called for every line that gets put into the report?