On Current update issue

[TeeSee]

I have a Mainform and a subform set to continuous form. The main form
holds a record of a Project. The sub form holds/displays three
companies involved in the "project"
On the main form I have two text boxes one wit ProjectID and one with
CompanyID. The strSQL uses them to create the correct recordset.
On opening the form the current event has the following code ....
Set db = CurrentDb()
Set rst = db.OpenRecordset(strSQL, dbOpenDynaset)
If rst.BOF And rst.EOF Then
Me.cmdViewData.ForeColor = vbBlack
Else
Me.cmdViewData.ForeColor = vbRed
End If
So for the first company on the subform (if there is a record in the
recordset) the ForeColor turns red. (As I intended)
When I now click on the second company name I can see the txtBox on
the main form change correctly but if there are no records in the
underlying table with the new combination of projectID and CompanyID I
can't seem to find the way to update the button foreColor.
If this makes sense could someone please help. Thanks

 

[Gina Whipp]

TeeSee,

Trying to do this in a continous form without using Conditinal Formatting is
not possible the traditional way. I was recently told about some code which
may work but I have never used it...
http://msdn.microsoft.com/en-us/library/aa139965(office.10).aspx

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm