ListBox values

[Guest]

Hello,

i have listbox which display results from a query. the query displays
availablity for an employee, so therefore the employee could have more then
one available dat for an order. this displays an employee more then once.

is there a way to do a "distinct" type of function with this listbox. what
can i do to just display the employee id just once, i have subform which
displays the rest of the information.

can anyone help ?

thank you

 

[Rick Brandt]

Hello,

i have listbox which display results from a query. the query displays
availablity for an employee, so therefore the employee could have
more then one available dat for an order. this displays an employee
more then once.

is there a way to do a "distinct" type of function with this listbox.
what can i do to just display the employee id just once, i have
subform which displays the rest of the information.

can anyone help ?

thank you

Set the query to "Unique Values = Yes". It's in the property sheet for the
query.

 

[Guest]

Thanks for the quick response,

i tried this and it works but it interupts a subform which i have set up in
one of the forms.

is there no way of doing this on the form properties, by using VBA or
something.

thanks again !

 

[Rick Brandt]

Thanks for the quick response,

i tried this and it works but it interupts a subform which i have set
up in one of the forms.

I have no idea what you mean by this. You would change the query that is
used as the Rowsource for the ListBox. This should have zero affect on any
other objects unless another object is using that same query. If that is the
case then create a separate query for the ListBox or just use a SQL
statement instead of a saved query name.