Designing a Combo Box to list Table Field Names

[efinnen]

Here's the deal, and I preface my post by saying I appreciate any help or advice that can be given to my situation.<br><br>Background : I'm trying to do data analysis on landuse data from various types of municiplaities. And I'm assuming that all the data that will be required for my analysis will be in the imported data. But some people will name fields differently. (i.e. land use, land_use, luse etc). So what I would like to do is design a combo box that lists field names and asks which field names correspons to LANDUSE, which one for ACREAGE etc??<br><br>So does anyone have any ideas how to give a user the ability to select a specific field name corresponding to a table, which we don't know the exact table structure until it gets imported in the earlier step.<br><br>Thanks<br>Eric<br><A HREF="mailto:efinnen@ithink.net">efinnen@ithink.net</A><br><br>p.s. I hope I wasn't too vague, Please contact me with any advice or further questions.

 

[DougP]

This is Some High End stuff you are asking for.<br>You need a way to open the data and get the field names first. this is done in VBA.<br>Then you need a list of the field names in your Import table. <br>It might be easier to put these filed name ain a Listbox instead of a combo box and then click on one list and match it to the other list.<br>Create a third list that has the new import info in it.<br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.