Filter in Combo Box

[matethreat]

Hello Everyone,

I have a combo box that looks up Job Numbers from a table. The problem I am having is that the same job number appears many times in the table and I would like the combo box to just show each unique number just once.

Is this possible?

 

[ZmrAbdulla]

Hi,
If the combo does not have another field that is a primary key, then go to the RowSource of the combo and change the

"SELECT [TbleName].[FieldName]......" to

"SELECT Distinct[TbleName].[FieldName]......"

regards

Zameer Abdulla

http://www.geocities.com/zameerabd/

 

[matethreat]

Thanks Zameer,

That did the trick.

Aaron