| | |
|
|
|
Combo Box |
|---|
| message from =?Utf-8?B?Sm9obkx1dGU=?= on 10 May 2004 |
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 replied to =?Utf-8?B?Sm9obkx1dGU=?= on 11 May 2004 |
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.
John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
|
| =?Utf-8?B?Sm9obkx1dGU=?= replied to =?Utf-8?B?Sm9obkx1dGU=?= on 10 May 2004 |
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.
|
|
Archived message: Combo Box (Microsoft Access)
