Coverting Text Field to Combo Box Field Without Losing Data

[pclutts]

I have a text field in table A where I enter County names. I want to convert that field to a combo box where I look up the County names in table B. However, I don't want to loose the County data I have already loaded in table A in the process. Can someone advise me on how to do that, if it's possible? Thanks in advance.

 

[thouston]

Make a query that groups the County names in your table, then use the query to make your combo box. This will mean that each County name only occurs once, your table is untouched and also if any new counties are added to the table they will show up automatically in the combo box.