trying to populate a single combo box with distinct values 1

[miscluce]

I have a form with a combo box (cboMake) on it. I have a table(tblCar).
I am trying to populate distinct values into a combo box and access is not working like SQL?

I thought his would work but I guees not. Can someone tell me what I am doing wrong? I am getting a object variable or with variable not set error.

my code:

Private Sub Form_Load()

Me.cboMake.Recordset = "SELECT DISTINCT * FROM tblCar"

End Sub

 

[miscluce]

Also, when I use the sql/query in Access and put DIstinct under the criteria and that returns no results??

 

[grgimpy]

use

Me.cboMake.RowSource = "SELECT DISTINCT * FROM tblCar"


instead

 

[grgimpy]

also, i think you need to specify the actual field when using "Distinct." i'm not sure about that though.

 

[miscluce]

thanks. thats is right, its rowsource. I missed that.