[AccessD] I am trying to set a value in a combo box to a certainvalue, if another check box on

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
>
***********************************************************************************************************

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com 
http://databaseadvisors.com/mailman/listinfo/accessd 
Website: http://www.databaseadvisors.com