Auto-Populate Form Field

[Stimpy707]

Access newbie here. I read through some of the posts relating to
auto-populating combo boxes but either I'm just not getting it or the thing
I'm trying to do is somewhat different. Here is what I could really use some
help with...

I've created a table that has two columns; Part Number & Description. The
part numbers are unique but the descriptions may be duplicated. I will
populate the Part Number table as needed.

In a separate form I would like to use a combo box to select the part number
and upon tabbing/entering the appropriate part number a second field called
"Description" would be automatically filled in with the description from the
Part Number table.

I've tried created an interim query based on the Part Number table and
relate the Description field on the form to the actual descrptive text but
all I've been able to do is auto-populate the Description field on the form
with the ID number.

Below is another description of what I'm trying to do.

Part Number table:
ID1 20015 COVER PANEL
ID2 20027 SHIELD, ADAPTER
ETC...

Rejection form:
type "2001" into part number field and have "Cover Panel" autofill in second
field.

Thanks in advance with any help.

 

[Jeff Boyce]

In the AfterUpdate event of the combobox, you'd add something like
(untested):

Me!YourTextDescription = Me!cboYourCombobox.Column(1)

(where the Column(n) number is zero-based ... start counting 0, 1, ...)

Regards

Jeff Boyce
Microsoft Office/Access MVP