Forms with Combo Box

I have a form which has two separate line items, one is for part number and
another is for part description, each has its own combo box for selections.

My questions is when I select the part number from the part number line and
combo box is there a way to set it up so based on the part number selection,
to automatically populate the part description line?

"Scout06" wrote in message
...
I have a form which has two separate line items, one is for part number and
another is for part description, each has its own combo box for
selections.

My questions is when I select the part number from the part number line
and
combo box is there a way to set it up so based on the part number
selection,
to automatically populate the part description line?

Use an unbound textbox and refer to an additional column in the PartNumber
combo:

= cboPartNumber.Column(1)
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Arvin, thanks for your quick responce.

I have a table named Part Numbers and Descriptions, with two columns one
Material
No and the other Part Description.

So when I create the unbound text box, will I use the =
cboPartNumber.Column(1)
as the entry for the control source or is there something more?

thanks

"Arvin Meyer [MVP]" wrote:

"Scout06" wrote in message
...
I have a form which has two separate line items, one is for part number and
another is for part description, each has its own combo box for
selections.

My questions is when I select the part number from the part number line
and
combo box is there a way to set it up so based on the part number
selection,
to automatically populate the part description line?

Use an unbound textbox and refer to an additional column in the PartNumber
combo:

= cboPartNumber.Column(1)
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Arvin,

ok I have it working now, were when you chose a part number form the combo
box the description populates automatically.

Now, is there a way to make the automatically populated part description, to
now show up in the part description table?

"Scout06" wrote:

Arvin, thanks for your quick responce.

I have a table named Part Numbers and Descriptions, with two columns one
Material
No and the other Part Description.

So when I create the unbound text box, will I use the =
cboPartNumber.Column(1)
as the entry for the control source or is there something more?

thanks

"Arvin Meyer [MVP]" wrote:

"Scout06" wrote in message
...
I have a form which has two separate line items, one is for part number and
another is for part description, each has its own combo box for
selections.

My questions is when I select the part number from the part number line
and
combo box is there a way to set it up so based on the part number
selection,
to automatically populate the part description line?

Use an unbound textbox and refer to an additional column in the PartNumber
combo:

= cboPartNumber.Column(1)
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Scout06" wrote in message
...
Arvin,

ok I have it working now, were when you chose a part number form the combo
box the description populates automatically.

Now, is there a way to make the automatically populated part description,
to
now show up in the part description table?

Remember Relational Database principles. No duplication of data, and no data
may depend upon another field other that the Key:

"The Key, the Key, and nothing but the Key"

So ... for proper design you definitely do not want to store the description
more than once, and that once should be in the table which has the part
number as the primary key.

Now, you say, but I need to see it in reports. Ah! I say, go forth and build
a query and all will be good. grin

Post back with table and field names if you need further assistance.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com