combo box query

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

Thats nice.

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

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????

Put this in the data source for the combo box:

Code:

---

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

---

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.

Quote:

---

Originally Posted by koolsid

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.