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.
--
Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/
> "M_Walker" <u54752@uwe> wrote in message news:9c0e78a7bcd74@uwe...
>> 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
>>
>
>
Similar Threads
