Combo Box with related Fields showing on top

[Guest]

I know this has been discussed before but it's hard to find.

my combo box in a sub form selects a numerical value stored as the ItemID
but I have to use a related "name" field to cover that combo box so it is
identifiable to the user. I have multible: Name, Company, Phone, Fax that I
need to show

How do I get those to stand out 1) after the combo box selection and 2) when
the form opens?

 

[Jeff Boyce]

Chris

I don't understand what you mean by "a related name field to cover that
combo box".

Are you saying you have a combo box AND a text box? If so, you (and Access)
are working harder than you need to.

A combo box allows for multiple fields to be displayed while it it dropped
down. This makes it easier to identify the correct row/record. A combo box
also allows one field to be stored and another to be displayed. This is
done by setting the width of the "bound" field to 0 ... and is usually done
by making the ID field the first field in the combo box's underlying query,
then setting the width to 0.

Or am I missing something?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

I make this more complicated than I need but it's fun.

1) There are three main items: A. Jobs B. Contacts C. Notes

2) Jobs are related to multiple Notes.

3) Multiple Jobs are related to multiple Contacts. To solve this I use an
intermediate table called "Contact Relations" i.e. RelationID, ContactID, and
JobID.

4) The only field that shows when I select a contact is "ContactID" from the
"Contact Relations" table. The Form source is a query that incorporates both
the "Contact Relations" table and the "Contacts" table the Name, Phone etc.
To cause these to show on the combo box I have to place that field from the
query over top the combo box.

Now the question. When I make a selection from the combo box OR when I open
the form, the first record does not show the the "overlayed" fields. How do
I get those fields to show in both cases (i.e. 1) upon opening the form and
2) upon selection)?
--
Chris Hayes
Newby

Chris

I don't understand what you mean by "a related name field to cover that
combo box".

Are you saying you have a combo box AND a text box? If so, you (and Access)
are working harder than you need to.

A combo box allows for multiple fields to be displayed while it it dropped
down. This makes it easier to identify the correct row/record. A combo box
also allows one field to be stored and another to be displayed. This is
done by setting the width of the "bound" field to 0 ... and is usually done
by making the ID field the first field in the combo box's underlying query,
then setting the width to 0.

Or am I missing something?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jeff Boyce]

I still don't follow the "overlay field".

Regards

Jeff Boyce
Microsoft Office/Access MVP

I make this more complicated than I need but it's fun.

1) There are three main items: A. Jobs B. Contacts C. Notes

2) Jobs are related to multiple Notes.

3) Multiple Jobs are related to multiple Contacts. To solve this I use an
intermediate table called "Contact Relations" i.e. RelationID, ContactID,
and
JobID.

4) The only field that shows when I select a contact is "ContactID" from
the
"Contact Relations" table. The Form source is a query that incorporates
both
the "Contact Relations" table and the "Contacts" table the Name, Phone
etc.
To cause these to show on the combo box I have to place that field from
the
query over top the combo box.

Now the question. When I make a selection from the combo box OR when I
open
the form, the first record does not show the the "overlayed" fields. How
do
I get those fields to show in both cases (i.e. 1) upon opening the form
and
2) upon selection)?

 

[Guest]

If I could email you a print screen would that help?

 

[Guest]

I figured it out. In the "onload" event I have a macro that goes to a new
record. Problem solved.