Change Table Display Control and Row Source 1

[sabloomer]

I am working on a project where I am given import templates in Excel (Field Name, Size, Field Type, Valid Entries, and Notes) and I have to create an Access table that matches it so people can start entering data and ultimately import that data into our new accounting system. I can use code to make the table with the names, types, and sizes I need, but I cannot figure out how to use code to change the DisplayControl, RowSourceType, and RowSource. I want to take the Valid Entries section and use it to limit data entry to just these types without having to touch each one by hand. My goal was to change the DisplayControl to ComboBox, RowSourceType to ValueList and then set the RowSource to a list of the valid entries.

I have almost 200 import templates to work with and each one has 5 to 10 fields that have restricted values. That is a lot of manual work. I found article

http://www.tek-tips.com/viewthread.cfm?qid=1109661

but I couldn’t get it to work.

Thank You,

sabloomer

 

[Zion7]

Not sure if I follow 100% but,

Me.combo.RowSourceType = "Value List"
Me.combo.Rowsource = "Canada;USA;Egypt;Peru

 

[sabloomer]

Zion7,

Can you do that directly to the table instead of a combo box on a form?

Thanks for the help,

sabloomer

 

[Zion7]

I don't believe so...?

I don't think DAO or ADOX specifies controls,
when creating fields.
Simply constraints, sizes, nullables indexes etc...

 

[sabloomer]

Thank you for your help.

 

[PHV]

Can you do that directly to the table instead of a combo box on a form
Have a look here:

http://www.mvps.org/access/lookupfields.htm

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886