Gustav Brock
gustav at cactus.dk
Thu Jul 3 12:40:24 CDT 2003
Hi John You're welcome! Best wishes for the 4th of July. /gustav > Again Gustav, you are the man! I was, as usual, over thinking the > problem...I knew I was going to be kicking myself. I was very close...I > tried, "Me!sfExit.Form!numWhyLeft.Value = "DECEASED"", which is the > equivalent of 1. I can't believe I didn't at least stumble on this one. > Thanks again! Take care! > John W Clark >>>> gustav at cactus.dk 07/03/03 11:49AM >>> > Hi John > You need to set the value of the control itself: > Me!sfExit.Form!numWhyLeft.Value = 1 > /gustav >> I am trying to set a value in a combo box to a certain value, if >> another >> check box on the form is checked true. The only twist is that the >> combo >> box is in a subform, but that shouldn't be a huge deal...just >> slightly >> different syntax. I have tried the folling methods, but it errors out >> on both: >> Me!sfExit.Form!numWhyLeft.Column(1) = 1 >> Me!sfExit.Form!numWhyLeft.Column(0) = "DECEASED" >> The error that I am getting is: >> >> *********************************************************************************************************** >> Run-time error '451': >> Property let procedure not defined and property get procedure did >> not return an object >> >> ***********************************************************************************************************