Setting Property Value for a combo box

[jeffhanner10@gmail.com]

I use the following command to set a value to the "CLFacilityOwnerName" combo box on a form. All the other property values that I'm am setting for different forms work, but they are just text boxes.



#
DoCmd.SetProperty "CLFacilityOwnerName", acPropertyValue, CFacilityOwnerName1
#
Why doesn't this work on a combo box?

[moke123]

wouldn't something like this be easier?

Me.Mycombobox = MyValue

[Micron]

I would agree with Moke123 that just setting the default property to something ought to be simpler. However, if it's not working for you on a combo on a form but it is for other controls, that's an oddity. The fact that it's not working in a particular instance makes me think that there's a subform or navigation form involved. If there is, then neither method is going to work if the reference isn't correct.

[June7]

I agree with moke123 suggested syntax to set a data control's value. Also, Value is default property of data controls, don't even have to reference it.

Me.CLFacilityOwnerName = Me.CFacilityOwnerName1

I also wonder why need to do this in code. If facility owner name is already in CFacilityOwnerName1, why need to repeat it in CLFacilityOwnerName?

[jeffhanner10@gmail.com]

To both Moke123 and June7,
Thanks for your help, but a misspelling caused the problem. The original code worked.

Thanks again.

[Mickjav]

Are you using Option Explicit if so it should have picked up that error??

mick