combo box displaying primary key not description

[natalie]

Hi, can you please help me!
i have two combo boxes that are dependent of each other, called "Problem1"
and "Problem2", and two list boxes that are dependent on them called
"Solution" and "Subsolution". In some cases, when an item in "Problem1" is
chosen, it could have a "Problem2"; if so, "Problem2" combo box fills out.
When a selection is made form the "Problem2", it fils out the list box of
"Solution" to display all of the possible solutions. Some of these solutions
have got "SubSolution" hich is displayed if a "Solution" is chosen.
this is all workign fine on th form, but when ti comes to doing a mail merge
that is based on these fields, their ID come up instead of the text that i
want. in the tables and query it stores the text but how comes when i use
mail merge it changes?
Many thanks, hopefully i explained it enough!

 

[John W. Vinson]

Hi, can you please help me!
i have two combo boxes that are dependent of each other, called "Problem1"
and "Problem2", and two list boxes that are dependent on them called
"Solution" and "Subsolution". In some cases, when an item in "Problem1" is
chosen, it could have a "Problem2"; if so, "Problem2" combo box fills out.
When a selection is made form the "Problem2", it fils out the list box of
"Solution" to display all of the possible solutions. Some of these solutions
have got "SubSolution" hich is displayed if a "Solution" is chosen.
this is all workign fine on th form, but when ti comes to doing a mail merge
that is based on these fields, their ID come up instead of the text that i
want. in the tables and query it stores the text but how comes when i use
mail merge it changes?
Many thanks, hopefully i explained it enough!

You are yet another victim of Microsoft's Lookup Field misfeature. The table
and the query APPEAR to contain the text, *but they do not*. They contain a
numeric ID; that simple fact is concealed from view by the "oh so helpful
(NOT!)" Lookup combo.

Base your mailmerge on a query explicitly joining your table to the lookup
table, and pulling the description from where it actually resides - *in the
lookup table*, and noplace else.

 

[natalie]

Thing is, i have not used the Lookup function; i typed in my own SELECT
statements to display the items in the combo boxes.
When i get rid of the primary key in the statement, the Problem2 combo box
does not work properly, so no items are shown.

 

[John W. Vinson]

Thing is, i have not used the Lookup function; i typed in my own SELECT
statements to display the items in the combo boxes.
When i get rid of the primary key in the statement, the Problem2 combo box
does not work properly, so no items are shown.

Please post the SQL. I'm not quite following what you're doing here!