Problem with Combo box information in table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a combo box in a form that is built from a table. The table
contains 2 fields- an ID(PK) and the course status text which is Passing,
Marginal or Failing.
The combo box works fine in the form, but in the table and report, the
choice made is displayed by the ID number rather than the text. How do I
change this?
Thanks in advance.
 
In the combo box field's property sheet (form and/or table), set the Column
Count to 2 (for two columns) and set the Column Widths to 0";1" (for a one
inch wide column). You may also need to change the List Width value from
Auto to whatever size you set for the total list width (Auto restricts the
list width to the width of combo box).

I have created a combo box in a form that is built from a table. The table
contains 2 fields- an ID(PK) and the course status text which is Passing,
Marginal or Failing.
The combo box works fine in the form, but in the table and report, the
choice made is displayed by the ID number rather than the text. How do I
change this?
Thanks in advance.
 
On the table, you can set a combo-box identical to the form's where the
property sheet's Column Count is 2 and the Column Widths is set to 0";1",
where zero is the width in inches of the first column you want to exclude
and one is the width in inches of the second column you want displayed.

In the report you are most likely using a text box for the value, in which
case you will need to set the text box's Control Source to a dLookup
function call as in:

=dLookup("TextFieldName", "TableName", "IndexFieldName = " &
me.IndexFieldName)

you may also need to set a hidden field on the report to contain the
IndexFieldName value to use in the me.IndexFieldName part of the statement.

I have created a combo box in a form that is built from a table. The table
contains 2 fields- an ID(PK) and the course status text which is Passing,
Marginal or Failing.
The combo box works fine in the form, but in the table and report, the
choice made is displayed by the ID number rather than the text. How do I
change this?
Thanks in advance.
 
I want to thank you for the help. I am still having problem with the report
showing the information correctly. It has been awhile since I have built
dLookups. THe information appears correctly in the forms and table.
The tables that hold the information are 2;
Course Status- which has 2 fields- ID (autonumber) and Course Status-text;
and Students Info which has the same field names and types. I used the advice
you gave me and set the lookup table as directed.
Thanks again.
 
Still having problems with the information showing up properly in the report.
Using the form to enter a child's status, it does not reflect the status on
the report. Could you please give further help on the configuring the dLookup?
Thanks
 
Back
Top