Showing posts with label combobox. Show all posts
Showing posts with label combobox. Show all posts

9/05/2012

Bind combo box to primary key but display a description field in Access

no image Question: In Access 2003/XP/2000/97, I've set up a table that contains an autonumber field as the primary key and a description field. I want to be able to create a combo box that displays the description, but stores the primary key. How do I set up the combo box?
Answer: Quite often the primary key value can mean nothing to the user. Instead, there is a description field in the table that relays the meaning of the record. In Access you can link a combo box to the primary key, but display the description in the combo box itself.
To do this, first create a combo box object. Right-click on the combo box and select Properties from the popup menu.

7/16/2012

MS Access: Populate underlying table when new entries are keyed into combo box in Accesscombo box

MS Access: Populate underlying table when new entries are keyed into combo box in Accesscombo box
Also learn how to populate underlying table when new entries are keyed into combo box in Access 2007 | Access 2003/XP/2000/97.
Question: In Access 2003/XP/2000/97, I have a form that is bound to a table. I have created a combo box on this form that obtains its values from a field that resides in a different table from the one that the form is bound to. When I enter values in this combo box I want those values written back to the associated field. How do I setup the combo box so that entries in the combo box are written back to the field in the table it came from?

7/04/2012

Create new database file and transfer tables using VBA

Create new database file and transfer tables using VBA
Also learn how to populate underlying table using a popup form when new entries are keyed into combo box in Access 2007 | Access 2003/XP/2000/97.
Question: In Access 2003/XP/2000/97, I have a combo box that is populated from a table/query. How would one add an item to a combo box via popup form if a user enters a value that is not in the list?