Multiple/Duplicate Records in a ComboBox

[sha7jpm]

Sure this must be an easy one, but it is driving me crazy.

i have a drop down list so that the user selects which project they want to view , and the subform brings up the data.

problem is that the combobox has duplicate entries, i.e. many projects with the same code.

is there any way to make the subform still bring up all the details for the project but in the combobox list the project code only appears once.

as you can imagine the list can get pretty long.

tried the hide duplicates option, but does not seem to be avaliable within combo boxes.

thanks in advance

John

 

[antomack]

Build a group query behind the combo to select the details required, it should group similar details together so you'll only get one line for each project.

 

[sha7jpm]

ta!

many thanks!!