ListBox values


G

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
 
Ad

Advertisements

R

Rick Brandt

DonMoody said:
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.
 
G

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 !
 
Ad

Advertisements

R

Rick Brandt

DonMoody said:
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.
 

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


Top