combobox

[diederik]

hi all,

I want to create a optionlist in a form to use this for a report.
my idea was to use a combobox that gets its data from a table.
the problem is I can't get it to group de data. so it lists each option
numerous times. it does not list the different options but all the entries
in that field in the table

i've tried to group the data but i can't get it to group it.

I have a feeling I am overlooking something. because it can't be to
difficult.

anyone any idea how to do this?

thanks in advance

diederik

 

[Jeff Boyce]

Diederik

One way to get "one of each" is to base your combo box on a query, and set
the query's Unique Values property to "Yes".

Good luck!

Jeff Boyce
<Access MVP>

 

[Dan Artuso]

Hi,
You can try:
Select Distinct yourField From yourTable Order By yourField

as the combo's row source, assuming your only pulling one field.

 

[diederik]

thanks guys
it is sort of what I did before
first I grouped the query that is autocreated by access and but strange
enough it doesn't group , or it doesn't show the data

But when I use a seperate query it works.