Prev: what is wrong with this update query?
Next: seeking a field
From: Stimpy707 on 24 Jun 2008 17:46
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.
From: scubadiver on 25 Jun 2008 05:26

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" wrote:

> 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.
From: Stimpy707 on 25 Jun 2008 18:43
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.

"scubadiver" wrote:

>
> 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" wrote:
>
> > 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.
 | 
Pages: 1
Prev: what is wrong with this update query?
Next: seeking a field