Lookup Wizard

[Glen]

I used the lookup wizard to create a drop down list in my
Main Table in order to find values (peoples names)listed
in other tables..I did this 3 times and two of those
times were successful ; the drop down lists worked in
both the table AND the associated FORM. However, the
third field that i tried to create a drop down list for
works only in the Main Table, and in the associated FORM
the drop down box has both the persons name AND thier
Auto number ID Column but only the number will display &
NOT thier name.Is this because I created the Table (The
source of info) After I created the Form? How do I fix?
NOTE:All 3 drop down fields access information from 3
SEPARATE Tables
Please be kind in your terminologies as I am only a
beginner.
Thank You

 

[John Vinson]

I used the lookup wizard to create a drop down list in my
Main Table in order to find values (peoples names)listed
in other tables..I did this 3 times and two of those
times were successful ; the drop down lists worked in
both the table AND the associated FORM. However, the
third field that i tried to create a drop down list for
works only in the Main Table, and in the associated FORM
the drop down box has both the persons name AND thier
Auto number ID Column but only the number will display &
NOT thier name.Is this because I created the Table (The
source of info) After I created the Form? How do I fix?

Probably.

The Lookup Wizard does one thing that's good: it makes it a couple of
mouse clicks easier to put a Combo Box onto a Form.

That's the ONLY good thing it does, and it does a *lot* of harm. See

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

for a critique.

You don't need to define a Lookup Field in your table in order to put
a combo box on a form; try deleting the third field's combo off the
form altogether. Click the "magic wand" icon on the Forms Design
toolbox and then select the Combo Box tool; put the combo where you
want it, and follow the instructions.

And change all your table Lookups back to Textbox, would be my
recommendation!