DistinctRow On ComboBox

[hullstorage]

Hi All,
I have a combo box that shows me results for records on a given customer but it shows the the customers name for each record

how do i just show the customer name once

joe blogs has got 10 records this month so in the combo it show me joe bloggs 10 times

thanks

simon

 

[DCrake]

In the rowsource for the combo make it a group by customer Id query.

 

[hullstorage]

i have updated this now but i cannot select a customer on the combo
although it is now showing me only one customer which is great

error now saying that this recordset is not updateable

help

thanks

 

[hullstorage]

thanks

sorted it now