Multiple Occurances in Combo

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a combo that goes through and selects all projects from a table that
are being worked on by a particular employee who is selected from another
combo. Now this is working as expected however I seem to be getting 3
occurances of the same project in the drop down menu. say for instance i
select "1. Richard" in the employee box i then go to the combo with the
projects he is working on and the menu has:

Project B
Project G
Project B
Project G
Project B
Project G

this is despite the fact there is only one occurence of each project in the
table.

I'm a bit stumped on this as i have no such troubles with similar cascading
combos.

any help would be greatly appreciated.
thanks
 
change the SQL from

SELECT <fieldname>

to

SELECT DISTINCT <fieldname>
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combo box not populating subform 1
Excel VBA - counting cells by colors and names to it in two different rows. 0
What do you use your R-Pi for - which Projects are you planning!? 1
cascading combo display is blank sometimes (Access 2007) 2
Check box to control editablility of text box and return all recor 1
Self-Populating Combo Box 1
How do I invoice a cost to a custom built MS Access Accounting Database? 0
Combi box data entry 2

Back
Top