Subform Name in VBA Variable Definition Keeps Changing to Lower Case

[dgj32784]

This is really weird and I'm not sure what is going on. I have some VBA to check the values of two combo boxes on my forms against one another. I first define two variables to be the values in the combo boxes. I have this running on many forms but for some reason when I tried to replicate the functionality in another form, it keeps changing the text characters in the name of my subform to lowercase.

This is what it should be:

cbo1 = Forms.frmBMPQREHABCA.frmBMPQREHABCAsubform.Form.cb oBMPImp

But when I updated the VBA to be the name of the new form/subform, it kept changing the text after I typed to be the following:

cbo1 = Forms.frmBMPQREHABCA.frmBMPQrehabcasubform.Form.cb oBMPImp

The problem of course is that there is no form named "BMPQrehabcasubform" so when I click my command button that checks the values in the combo boxes I get an error.

Anyone know what in the world is going on? I've compacted and repaired to no avail.



Thanks,
David

[ssanfu]

Access is case insensitive AFAIK. I haven't seen syntax like what you have.

Maybe this will help:
Refer to Form and Subform properties and controls
http://access.mvps.org/access/forms/frm0031.htm

[June7]

You have the subform container control named the same as the form in the SourceObject property? I always name subform container control different from the object it holds, like ctrBMP or subBMP.

Somewhere, Access is finding the lower case version and using it. I have seen this with fieldnames and controlnames and it doesn't affect code performance so I just ignore.

[Missinglinq]

What they said! To the Access Gnomes

frmBMPQREHABCAsubform

and

frmBMPQrehabcasubform

are the same, identical thing! You need to look for another culprit, here! And unless the bit in Red

cbo1 = Forms.frmBMPQREHABCA.frmBMPQrehabcasubform.Form.cb oBMPImp

is a typo, that Space between cb and oBMPImp, which I assume is supposed to be cboBMPImp, could be it!

Also, the behavior you noted, of changing cases in names, does occur when you change it, somewhere. How it's formatted is dependent on its formatting the last time you typed it somewhere! Simply re-type it, as you want it, anywhere in a Code Module, and all instances will be converted to that formatting.

Linq ;0)>