ComboBox - Easy one!!!

[themanof83]

Ok guys this SHOULD be an easy one.....

I created a Union Query that transposes the columns in a table to the rows. This works perfectly!
I have used this query in the RowSource for a combo box I have on a form which displays the values in the query fine. Only problem is that I can only select the first row! If I try to select anything else then it just reverts back to the value in the first row!!! Strange.....

I also tried using a Select query instead which incorporated my original Union query for the row source but the effect is the same.

Any suggestions would b greatly welcomed.

Thanks.

 

[neileg]

If you use a union query then you won't have a PK in the dataset. I think that is the problem, although I'm not 100% sure. Usually, union queries suggest that your structure is not normalised.

 

[themanof83]

Thanks for your response Neil, is there any way I can move forward with this. Perhaps add a PK in the query????

 

[khawar]

Can you show the sql of combo