Combo box trouble....

[Noreene Patrick]

In my table and on the form, I have a combobox that the user chooses the plant the product comes from and the combobox has 2 colums: plantid(text) and minutes(number). The bound column on my table and form is 0 which of course is plantid such as CH.

The table holds it correctly and the form shows the selection correctly. But, the report shows the record number such as 1 or 0. The report is based on a query and even the query shows the column as text. But the report only shows a number and it has to be the record number since the minutes are not even these numbers. The minutes in the table are either 4 or 5.

What am I missing? If it shows correctly in the table, form and queries, why does it not show correctly in the report?

 

[boblarson]

You probably have used lookup fields in the table itself, which is causing you problems. If you remove the lookup fields from the tables and rely on combining the tables in your queries and then display them that way, they should show up correctly. That's one of the drawbacks to using lookup fields (should be done using forms and not in the tables themselves).

 

[Peter Reid]

What are the combobox values for 'Column Count' & 'Column Widths' on your report? How do these values compare to the combox values on your form?

Also, I thought that if you wanted to bind a combobox to the first field then you should set 'Bound Column' to 1 and not 0

 

[boblarson]

yes, that is true - in the properties, the bound column is set to 1 for column(0)

 

[Noreene Patrick]

Thanks to both of you!! By changing the bound column in my form form 0 to 1(which by doing this it didnt change the column info), it worked correctly in my report.

Thanks so much!!!!