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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Scott McDaniel (Microsoft Access MVP - EE MVE )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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

Helen FeddemaCommented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.