Hi to all..

Can anyone help me how to get value from query to form. I have form named productOrder, the field are productID,description, order,received,sold.

the rest of the field are key in by the user except sold which will get the value from query. How can i do that, what is the code..


Thanks...:)Hope to find answer.....

If you just want a single value, the DLookup() function may be better than a query. Can't be more specific without more information on wht you have and what you want.