At work they have been using a pretty simple form for the past few years that that base IT department made. I came along and customized the form a bit, making their lives easier with some drop down fields with following IF fields to give the rest of the text that did not fit in the drop down field due to the character limit.

They now want a way to insert about 60 lines into a drop down field or anyway that they can select a number, and it will populate the data that corresponds with that number. But, I do want that number to print.

Any ideas best way to do this?

Macros may be my only options, but Ive been trying to stay away from them, since the computers being used are on a server and have roaming users, and with 100 computers or so, and 140 employees that i have to enable macros on. just adds alot of work for me.

JBaker