Programmatically fixing an external control property

[Jerry]

We have several dozen Access databases for clients that
from time to time need altering. In this case, we
discovered a dropdown box that had its limittolist
property set to the wrong value. Is it possible to create
a tool(access database VBA) that the user will download to
their computer and execute, which will change the value of
that property.

I've looked at DAO and ADO functions. Have been able to
retrieve the forms name but I'm unable to obtain the
control name and change the property of that control. Is
this doable?

 

[Bob Bonta]

If the combo box is populated by a lookup table, you would
be better off providing a form which can add to the lookup
table and re-populate the combo box.

By turning the "LimitToList" property to false, you open
yourself to data integrity issues in that field and all
related tables.

v/r

Bob Bonta
Database Developer
Scientific Research Corporation
(e-mail address removed)