Combo Box

[Guest]

My primary key is a combo box in the table and form. In the form, how can I select an item from this combo box and have the complete record appear

Thanks!

 

[Guest]

After looking at this further, I need to reword my question. What I'd like to do is: in a form, enter data into my primary key (combo box) and also be able to select that data so that its complete record is found

----- JohnLute wrote: ----

My primary key is a combo box in the table and form. In the form, how can I select an item from this combo box and have the complete record appear

Thanks!

 

[John Vinson]

My primary key is a combo box in the table and form. In the form, how can I select an item from this combo box and have the complete record appear?

Thanks!

You're mistaken, misled by a Microsoft misfeature. Your Primary Key is
a numeric field, not a combo box.

A Combo Box IS NOT A DATA TYPE. It's a tool to display data! The
Lookup Wizard is a very deceptive and rather useless misfeature in my
opinion: see http://www.mvps.org/access/lookupfields.htm for a
critique.

To answer your question, you *do not* need a Lookup Field to
accomplish what you want. You cannot do what you want in a table
datasheet - no usable events; on a Form you should use the Combo Box
wizard in the form toolbox to create an unbound combo, using the
option "Use this combo box to find a record". If the wizard doesn't
cooperate post back - it involves a little bit of VBA code but it's
pretty easy.