Form control properties don't reflect changes to source table field properties

[M_Walker]

Hi
I have a back end database table tbl_WTW_METERS with a number of fields whose
values are set via combo box lookup from another table tbl_METER_LIST.
A form frm_METER_COMBOS in the front end database takes it's control values
from the fields in the linked table tbl_WTW_METERS.
I've changed the field properties of many of the fields in tbl_WTW_METERS
(Limit To List = Yes).

Does anyone know a way to get the form's control properties to 'refresh' and
reflect these changes without having to delete and re-add the controls for
every field?

(I've turned off Name AutoCorrect in my front end database as this caused
corruption during development - I wonder if this also prevents control
properties updating from source tables field properties?)

Thanks for any help you can give,
Michelle

 

[Ken Snell [MVP]]

Properties of a control are "fixed" at the time the control is created. For
the controls that you describe, they inherited the properties from the
backend table's field when you first created the control. From that point
on, the properties do not change unless you (1) change them manually; (2)
delete and recreate the control; (3) programmatically change them.

 

[M_Walker]

That's what I suspected but thanks for confirming Ken, just wanted to make
sure I hadn't missed something obvious.

Cheers,
Michelle

Properties of a control are "fixed" at the time the control is created. For
the controls that you describe, they inherited the properties from the
backend table's field when you first created the control. From that point
on, the properties do not change unless you (1) change them manually; (2)
delete and recreate the control; (3) programmatically change them.

Hi
I have a back end database table tbl_WTW_METERS with a number of fields

[quoted text clipped - 17 lines]

Thanks for any help you can give,
Michelle