Blank field

[jamccarley]

I have two fields on a form, PartNumber and PartDescription. As I have it now
you can look up data in either field and it brings up the corresponding data
in the other field. The problem is that only the part number shows up in the
table. The description field on the table is blank. I have tried using
relationships but they did not work. I am fairly new to access.

 

[pietlinden]

I have two fields on a form, PartNumber and PartDescription. As I have itnow
you can look up data in either field and it brings up the corresponding data
in the other field. The problem is that only the part number shows up in the
table. The description field on the table is blank. I have tried using
relationships but they did not work. I am fairly new to access.

You don't want the PartDescription field in any other table than the
Parts table. IF you want to see it somewhere, use a query... You
shouldn't be working directly in tables anyway -they're for storage,
not editing/adding data.

 

[jamccarley]

It won't show up in a query either. It is as if it is a blank field, but
there is information there on the form.

 

[John W. Vinson]

I have two fields on a form, PartNumber and PartDescription. As I have it now
you can look up data in either field and it brings up the corresponding data
in the other field. The problem is that only the part number shows up in the
table. The description field on the table is blank. I have tried using
relationships but they did not work. I am fairly new to access.

Actually a Form doesn't have fields (Tables do); it has Controls. What type of
control is each of these? Textbox, combo box, ...? If you open the form in
design view and view each control's Properties, what is its Control Source? If
it's a combo box, what is its RowSource?

 

[jamccarley]

The PartNumber control is a combo box and the Control source is my Part #
table and the Row source is also the Part # table. The PartDescription
control is also a combo box and the Contorl source is the Part # table and
the Row source is my Part Description table. Is there is another way to
select a part number and for the description to also show up. We have over
3000 parts in our plant and some people know the description, but not the
part # and some people know the part number and not the description. I need
them to be able to select either one and it bring up the corresponding data.
Thanks

 

[John W. Vinson]

The PartNumber control is a combo box and the Control source is my Part #
table and the Row source is also the Part # table.

Doublecheck that. The Control Source cannot be a table; it must be a field,
presumably NOT a field in the Part # table (there's no point in updating a
part number to itself!), but rather the part # field in your main form's
table.

The PartDescription
control is also a combo box and the Contorl source is the Part # table and
the Row source is my Part Description table. Is there is another way to
select a part number and for the description to also show up.

Typically the Parts table would have a PartNo (I'd avoid using the # character
in fieldnames) as a Primary Key, and a Description as a separate text field.
Your main table should NOT contain a description field; that should exist only
in the Parts table. However, it should have a PartNo field (I presume, I don't
know what table this form is updating).

This field could have two combo boxes bound to it. Both combos would use the
mainform table's PartNo as the Control Source; one would have a RowSource like

SELECT PartNo, Description FROM Parts ORDER BY PartNo;

and a ColumnWidths property of

0.5"; 1.5"

to display the PartNo when it's not dropped down and both fields when it is;
the second combo would have a RowSource

SELECT PartNo, Description FROM Parts ORDER BY Description;

with a ColumnWidths of

0"; 2"

to store the PartNo but display the description.