On a continuous form in Access 2000, there is a checkbox and a textbox. When I click the checkbox, I want the associated textbox to change backcolor to red. (this is actually a problem I'm trying to solve for a co-worker) However, it changes all the textboxes to red (there could be 1 - 50 check & textboxes). Of course, there's only one in design mode. The code goes like this:
How can I get just the one textbox to change color? Thanks.Code:if me!chkQT.checked then me!txtQT.backcolor = lngRed else me!txtQT.Backcolor = lngWhite end if




Reply With Quote