Change lookup Properties in multiple feilds

[RHH]

Is there any way to change the lookup properties in multiple feilds without
having to click each one in the design veiw?

I want to link about 60 different feilds with a drop down list another table.

I can go down and click each one, but it will take so long.

Thanks

 

[Allen Browne]

It is possible to set the DisplayControl property of the Field in the
TableDef.

You will also need to set the other properties (RowSource, Column Widths,
etc.) By the time you develop and test that code, it may have been easier to
set one field, copy and paste, and rename the field.

Hopefully you don't have 60 fields in the one table, all bound to the same
lookup. That would almost certainly indicate that you have repeating fields,
and the table should be redesigned so there is a related table where you can
enter 60 related *records* if needed, instead of 60 similar fields in one
record.

 

[Duane Hookom]

I addition to Allen's comments, many of us veteran developers never use
lookup fields defined in tables http://www.mvps.org/access/lookupfields.htm.