--
Aggie
John Vinson said:
Just create an Option Group control using the toolbox, and delete the
combo box.
Your table does NOT contain a field value list: it contains a numeric
ID. That basic fact is concealed from your view by Microsoft's
misleading Lookup Wizard misfeature. You can still use any suitable
control (option group, combo, textbox) on a Form, though.
John W. Vinson[MVP]
John, Thank you for your answer, that's reassuring. Now ..... I am
probably in error about alot of things and I truely appreciate your time to
answer. I understand the concept you have explained. I still don't
understand the mechanics nor does my form work properly with the options
group. I will go back to reading the books and trying to understand what
they are telling me. Unfortunately, most manuals create more questions than
they answer. The very fact that there is a "misfeature" in a Microsoft
program is to PREVENT home users from using and understanding the
applications. Why do I think that? Economics. If everyone with average or
above average intelligence could understand the manuels, there would not be
any need of higher education or classes which makes MONEY for the company. I
have a degree in medicine, pharmacology was easier to understand than the
Microsoft Manuals that came with my Access 2002 program. I apologize for
using you as a sounding board for my frustration, please forgive me. May
god bless you and thank you for the answer. Aggie
