importing structure problems

[Heidi]

I have a combo box that runs from a linked table. I now want to import the
table instead of leaving it linked. However, when I import it from my macro,
it turns the index on one of my fields on which screws up my combo box for
some reason. I've selected import structure and data, but it still imports
this one field as indexed when it wasn't originally. Argh. Any help?

 

[boblarson]

Are you using LOOKUP FIELDS within your table? If so, read this:

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

and get rid of them.
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
If my post was helpful to you, please rate the post.
__________________________________