Using query in form?

[electro]

I have a table with a lot of columns. I have two columns i want to prepair to be used in a tablesheet form. One with sizenumber and another with productnumber. I have a datasheet form where I want to use the data from sizenumber and productnumber writen as one ex. "3-345767" (first number is size and the second is productnumber). Well I succsesfully done this in a query table but I can't get it to work or sort in the form. Its greyed out. Any suggestion? Can I do this on another way?
I gonna get greyhaired of this..
Any suggestions would be help full!

 

[cuttsy]

Write a query

SELECT YourTable.YourField, (YourTable.SizeNumber & "-" & YourTable.ProductNumber) As YourNumber
FROM YourTable

Now make a new form and set the record source to be the above query.

That should work fine. If thats what you have already tried then I am stumped cos it works for me.