Connecting Tech Pros Worldwide Forums | Help | Site Map

Combo Box Question

Starwood
Guest
 
Posts: n/a
#1: Nov 13 '05
I have an existing table with two fields in it (Code and Description) that I
want to use to fill a field in a new database using a combo box on an Input
Form. I would like the user to see the Description field values in the
combo box pop-down list and, based on the selection, have the corresponding
Code field inserted into the new database field.

How do I define my combo box to do this?

Thanks




Momo4
Guest
 
Posts: n/a
#2: Nov 13 '05

re: Combo Box Question


The combo box wizard should do this for you. If Code is the primary
key of the table, the wizard will suggest hiding it. The one of the
last combo wizard options is to tell access where to store the key.

Closed Thread


Similar Microsoft Access / VBA bytes