Set Field Caption Property from Another Table

[safedir]

I have a survey table that uses the question number as the field name. I would like to set the caption property of each of the fields to the actual question. I have a table named Facility with two fields, Number and Question. Each Number is also a field name in a table named AllData. I want to use the corresponding Question as the caption for the field Number. I know I can copy and paste the information in the table design view, but this doesn't seem like it should be necessary.

 

[JeremyNYC]

You should be able to write code to do this fairly easily. Look into the tabledefs collection and tableDef object.

Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developer's section of the site for some helpful fundamentals.


Remember to reward helpful tips with the stars they deserve.