combo box duplicates

[j3andc]

I am using a combo box to populate data. I have 6 records currently in the table and 3 of them are the same. The combo box is listing all 3 when I am trying to select a new one. I want the list to only show the duplicates one time. How do I do this?

Jim

 

[bat17]

If you click on the builder button for the row source this will open a QBE grid. if you call up the property sheet for the query you can then select to have unique records.

HTH

Peter

 

[j3andc]

That worked exactly how I expected.

If I type in a new value, rather than select one from the list, shouldn't the list update itself the next time I look at it to include the new value?

 

[bat17]

only if it is bound to the record source and you have not set it to "Limit to List"

try it and see, just use a copy while you are developing

Peter

 

[j3andc]

This is going to sound stupid, but how do I know for sure that it is "bound to the record source"?

 

[bat17]

if the value changes as you change records then it is bound to the table behind the form.

Peter

 

[j3andc]

Ok.

If that is not happening, how do I change it so it is bound to the record source?

 

[bat17]

In the property sheet for the combo-box is a field called "Row Source" click in it and then use the drop down to pick the field you want to bind it to.


peter

 

[j3andc]

This is what it current says in the field.


SELECT DISTINCT [Song Title].[Text Direction] FROM [Song Title] ORDER BY [Song Title].[Text Direction];

Song Title is the table name
Text Direction is a field in that table.

 

[bat17]

my bad!!
That should have been Control Source not Row Source,

Sorry