Using a combo box in a form

[Guest]

I have a little problem that is driving me nuts! I have created a database
that has a form that when information is entered it creates a report. In my
form I have a combo box that lists a material number and a description. What
I would like to do is be able to choose a material number and have the
description pop up into another field. So far I have been able to figure
that out but my only problem is for some reason the description does not show
in the report. I took a look at the table and for some reason the
description does not show there either. Any suggestions how I can get this
to work?

 

[jleckrone]

It sounds like your description field is not bound to a field in your
table. Look at the design of your form and then look at your
description field on the form. If it says Unbound in the box, then you
need to change it to the name of the field in your table that holds the
description. Hope that helps!

 

[Guest]

I think it's bound to the table. I have the text box set up so the control
source is:

=[SAP TP Material Number].[Column](1)

And the name is Packaging Description.

The SAP TP Material Number is the Combo box which is set up to display the
material number and Column (1) is the description that I want to pop into the
text box.

Is there a better way you know of to make the description appear in a text
box and update the table?

 

[John Vinson]

I have a little problem that is driving me nuts! I have created a database
that has a form that when information is entered it creates a report. In my
form I have a combo box that lists a material number and a description. What
I would like to do is be able to choose a material number and have the
description pop up into another field. So far I have been able to figure
that out but my only problem is for some reason the description does not show
in the report. I took a look at the table and for some reason the
description does not show there either. Any suggestions how I can get this
to work?

You do NOT need to - and should not! - store the description
redundantly in your table. It should be stored *only* in the materials
table.

Base your Report on a Query joining its current table to the materials
table, and pick up the description from there. That's how relational
databases are designed to work!

John W. Vinson[MVP]

 

[Brian Bastl]

Kari,

If you've got an expression as the control source, the text box is unbound.

HTH,
Brian

I think it's bound to the table. I have the text box set up so the control
source is:

=[SAP TP Material Number].[Column](1)

And the name is Packaging Description.

The SAP TP Material Number is the Combo box which is set up to display the
material number and Column (1) is the description that I want to pop into the
text box.

Is there a better way you know of to make the description appear in a text
box and update the table?

It sounds like your description field is not bound to a field in your
table. Look at the design of your form and then look at your
description field on the form. If it says Unbound in the box, then you
need to change it to the name of the field in your table that holds the
description. Hope that helps!