Combo box HELP

[AckAttack]

I am creating a database and trying to use a combo box where multiple records have the same data entered, now the problem I have is when I open the drop down box i have that entry "ME" listed multiple times in the box, is there anyway I can fix this so I dont have a long list of the same thing?

My goal is to have every states abbreviation listed...just once.

 

[MarkK]

SELECT [COLOR="DarkRed"]DISTINCT[/COLOR] Field1, Field2 FROM Table

 

[AckAttack]

I'm going to sound pretty stupid but how do I do that. I am new to this and been fumbling around in the dark, learning as I go until I get everything right and can build a perfect one from scratch.

 

[MarkK]

...can build a perfect one from scratch.

That day never comes brother...
But the combo box, you want to check the RowSource property on the Data tab of the property sheet. It's most likely that there's an SQL statement in there now so you'd add that DISTINCT keyword and you don't get the dupes in the result set.

 

[AckAttack]

That day never comes brother...
quote]

I figured as much, but for the people I work with it will be ... well most of them anyways