Access 07 field conversion from combo box to text box not working

I am getting this infuriating message that I cannot seem to find any documentation about.  I have a table (which I did not set up) that has 9 or 10 lookups for key fields.  Unfortunately, you can't use update or delete queries on these (which I need to do) so I plan to use form combo boxes for the lookups rather than in-field lookups.  The problem is this:  every time I try to convert the combo box fields in teh table to a text box, I get the following error:

"You have changed the 'blah blah" lookup column to be displayed by a text box.  After you save the table, this change will make the column read-only and lose the lookup properties".

I am fine with losing the lookup properties, I have issues with it being read-only and I cannot figure out how to un-read-only it.  I'm sure it's simple and stupid but any help is appreciated.

Help!
menaurielAsked:
Who is Participating?
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor Infotrakker SoftwareCommented:
I'm wondering if these aren't perhaps one of the new Mutli-Valued fields? I've not seen that message appear, and as you said didn't find anything about it in a search, so I'm not sure. Can you show a screenshot of that error?

It would seem to be quicker to build a new column for each of those, then run an Append query to move the data from ColumnA to ColumnB, and then Delete ColumnA.
0
 
menaurielAuthor Commented:
It might also be good to note that the fields that were connected to TABLES that I changed seem to have converted ok, the ones with typed in lists are presenting the problems.
0
 
menaurielAuthor Commented:
LSM, that is precisely what I plan to do since I have thankfully not yet used those fields for anything except one form, which will need to be modified using combo boxes anyway.  It is one of the new multi-valued fields, and I do not plan to use them again....the read-only thing is hugely frustrating.
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
Helen FeddemaConnect With a Mentor Commented:
If that that doesn't work, make a new table (without the lookups), and write an append query to transfer data from the old (problem) table to the new one.
0
 
menaurielAuthor Commented:
Would really just like to know how to undo this read-only thing rather than monkeying through appends and updates, but will do what I have to do.  I think Microsoft needs to issue a warning that when you use the multi-value feature, this field cannot be updated using an update query.
0
 
Helen FeddemaCommented:
Working with multi-valued fields in queries is quite problematic.  I might write an Access Archon article on this topic.  I did one a while back, when Access 2007 is new, but I didn't deal with using them in queries.  Users like them, but they are much, much harder for developers to work with (as opposed to using standard lookup tables, or junction tables for many-to-many relationships).
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.