Value List / I don't know if it'll work. Checking with the experts

[applevacross]

I have two combo boxes I would like to create. The information in one is UserName, the other is NT USerName
I did a system audit and created an RTF file which has 4000 of each. I'd like to add these to my value lists without having to manually add the quotes and semi colon.

Is there a way to automate this in note pad then copy over to the value list? Meaning use the replace feature to automatically add the quotes and semicolon to each name?

As always your expert knowledge is greatly appreciated.

Thanks to all in advance!

 

[PHV]

Why not paste append in an access table you can then use as RowSource for the combo?

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

 

[applevacross]

I thought about that as well

Can I select the already available source when configuring the box and have the selection save into the field I want it to [not the newly appended fields]? Reason being; The name and NT name fields are already fields within the table. Management decided on a different convention for both. Therefore I have to add this new data with different field names. That is why I cannot use the current data within. Let me know if that didn't make sense; kinda rambles but that is the best I can explain. As always I appreciate your help PH!