Me.DOExp - Method or data member not found

[GraeagleBill]

I have a statement that produces as error when VBA is compiled while in Debug. I thought perhaps I had a corrupted control, so I deleted the control and built a new one from the tools menu, but I still get the error. I don't get any compilation errors when I "Compress & Repair". And, the Conditional Formatting functions normally when the value is tested during normal form display.



Sometimes one can get into problems if the ControlSource name is the same as the control name, but that's not the case here. Any ideas what might be going on here?


The error:


The Control:


The form's RecordSource query:

[ssanfu]

According to your picture, the field "DOExp" is bound to the control "tbDOExp".

Try changing the line to reference the control name:

curExpiration = Me.tbDOExp

Is "curExpiration" a control on the form? Curious because I do not see where "curAmount" or "curExpiration" was declared in "Sub tbAmtPmt".

[GraeagleBill]

Wow! I'm not thinking at all today............SIGH!

Code should be:

curAmount = Me.tbAmtPmt
curExpiration = Me.tbDOExp

curAmount and curExpiration are both global to the module.

Thanks,
Bill

[ssanfu]

Glad you have it working.

I use the prefix "g" or "g_" for globally declared variables (depending in the phase of the moon).
Don't know *why* I expect everyone to follow my naming convention. I mean, ell, why wouldn't you???

[GraeagleBill]

Steve,

I use gblxxxxxxxxx but only when the variables are dim'd in a module dedicated to an assortment of global variables needed throughout an app. Typically, you'll see a module within my apps like ModGlobalVars for such purposes.

Thanks for waking me up earlier,
Bill