combo box query

[Siddharth Rout]

There is a combo box in a form and there is a table say tableone.mdb. the table has a field say 'name'.

the combo box should show all the names in that field. I don't want to use the data control

[Ecniv]

Thats nice.

So what have you done so far?
Searched the forums (button at top)?
Checked online for tutorials??

[Siddharth Rout]

i am sorry i didn't quite catch that...

i have checked msdn. couldn't find a solution

is it possible to do what i have asked for????

[Br1an_g]

Put this in the data source for the combo box:

SELECT DISTINCTROW Table1.Name 
FROM Table1
GROUP BY Table1.Name;

[Siddharth Rout]

Thanks I will try that
I would like to point out that I am using Vb as a Frond End and Access as a back End.

[Br1an_g]

i tried but is it not working....

is it a vb code?

this is to be put in the data source of your combo box. not in a vb module.

if it is not working..is there an error message? can you clarify how it is not working.