Hide Duplicates

[infinitx]

Hi,

I have a combo box that has a bunch of values. Some values repeat themselves. How do I hide those that are duplicates? I tried this:

"Form_ICL.Combo1.HideDuplicates"
But it gives me this error:

"Compile Error: Invalid use of property."

How do I hide the duplicate values in a combo box?

Also, when I try to make a query and create the same form using the created query, the form appears blank when I view it so I would like to do this using the tables.

Thanks in advance!

 

[o1110010]

If it was myself, I'd create a second query (perhaps with the Find Unmatched Query Wizard) that is based off the table or query of the data you are currently using for the form. Then I'd switch the comboboxes row source to this second query. And if you don't want to use a query directly for this combobox, you can have the query dump the data into a table by changing it to a Make-Table query.

 

[infinitx]

Database

Hi, thanks for responding....

Here's the stripped down version of the program.

What are your suggestions?

I want to filter data that has not been entered yet! (Sort of like generic coding).

 

[o1110010]

Yikes. No descriptions anywhere. Hard for me to figure out how things are connected to each other. The Relationships look like a spiders web. I'd totally fine with helping. I just need help to figure out what's going on. (Random thought: What does ICL stand for?) Can you provide any details?

I want to filter data that has not been entered yet! (Sort of like generic coding).

Do you mean not allow the user to enter data that's already been entered?

 

[neileg]

Your sample isn't a lot of help because I can't see the purpose of the combo. However, if your problem is ensuring that your combo does not contain duplicates, base the combo on a SELECT DISTINCT query. I'm not clear how you would get duplicates in the data, anyway, but there you go.

 

[infinitx]

ICL stands for Item Classification Level.

What I want to accomplish with the combo boxes is first have a screen where the user enters all of the classifications that they need:

Level 1 (ICL 1)

Math
Science

Level 2 (ICL 2)

Algebra
Calculus
Physics
Chemistry

Level 3 (ICL 3)

Factoring
Binomial Expansion
Imaginary Numbers
Graphing Inequalities
Speed
Distance
Combined Gas Law
Diffusion

I didn't put ICL 4 here for simplicity purposes!

Then on the form with the combo boxes, if the user picks:

Math from Combo Box 1
Combo Box 2 = Algebra & Calculus
Algerba from Combo Box 2
Combo Box 3 = Factoring & Binomial Expansion

After they have chosen what the levels are, the user will click a button and it will transfer the information from the Combo Boxes to Text Boxes on an "Add Item" Form.

Hope this clears it up. If you need any more clarification just say so.

Thanks Again!

 

[infinitx]

Got It!

Hi,

I got the answer to it.

Just use "Select Distinct...." instead of just "Select...."

You were right Neileg!

Also, thank you o1110010!