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 for any help.

 

[scubadiver]

Is there any particular reason why you need to record the description in the
form (when it is already stored in a table or query)?

What you need to do is have both columns in the combo box but make the
description invisible (by making the width of the column 0cm). In the
afterupdate event of the combo put the following

[textbox field] = [combobox].column(1)

This should record the description from the part number in the text box.

 

[Stimpy707]

We manufacture machined parts. The form is for creating records of defective
parts that were made. That form will be called "Non Conformance" and will
contain info such as "Customer, Customer PO#, Part Number, Part Description,
etc..." It was made from the Non Conformance table.

I have a table called Part Numbers that has two fields: Part Number &
Description.

The NC form will store a detailed record of each incidence when defective
parts were manufactured. When filling out the form I would prefer to be able
to select the Part Number (unique) in one field and have the Description
automatically filled in. I want to do this to eliminate the possibility of
attaching the wrong part description to a part number.

I tried what you suggested but I must be doing something wrong. I'm too new
at this. I think I need to step back and purchase a book or take a class.

Thanks for your help.

Is there any particular reason why you need to record the description in the
form (when it is already stored in a table or query)?

What you need to do is have both columns in the combo box but make the
description invisible (by making the width of the column 0cm). In the
afterupdate event of the combo put the following

[textbox field] = [combobox].column(1)

This should record the description from the part number in the text box.

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 for any help.

 

[Tammy Ratliff]

I have a similar problem. I have a form developed from the wizard. I have
added calculations in the form, but don't know how to make the 'answers'
populate to the table.

Is there any particular reason why you need to record the description in the
form (when it is already stored in a table or query)?

What you need to do is have both columns in the combo box but make the
description invisible (by making the width of the column 0cm). In the
afterupdate event of the combo put the following

[textbox field] = [combobox].column(1)

This should record the description from the part number in the text box.

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 for any help.