Control Values

[CementCarver]

Still building my audit table functionality, but one line of code I borrowed was to test the existing value of a control, using Access 2010

ctl.value causes an error.

but after you input the period after the variable name ctl you get the options of that control object. But there is no listing for the value, or at least I do not know the equivalent.

Does anyone have any documentation on this object's properties? Or the right answer?



CementCarver

[RuralGuy]

You need to show all of your code. Labels are controls too and have no .Value property.

[CementCarver]

After more research I found out that not all object in a form support the .value criteria. You need to test whether the control is a text or checkbox first, before you can apply the control.value parameters.

CC