Querying a multivalue field.

[The Archn00b]

A have a query that selects a multivalue field. The query forms the record source for a subform. The text values in the multivalue field are displayed in the query, but when I save this and view the data in the subform datasheet view the values revert to the primary key values. They are 1,2,3,4 instead of the text values. Does any one know what is going on?

Thanks!

 

[JHB]

Check the Column Count, Column Widths and the Bound Column property.
Else post a stripped version of your database with some sample data, (zip it) + information on in which form you have the problem.

 

[The Archn00b]

Column Count, Column Widths and the Bound Column

These are in the property sheet?

 

[JHB]

These are in the property sheet?

Yes - but did you check if they have the right value/ set up.
As mention before, post a stripped version of your database with some sample data, (zip it) + information on in which form you have the problem.