B
Bob
If you're querying the same table that stores all of the
employees and their associated departments then you need
to add DISTINCT to the SQL query statement in the query
for your combobox.
You could also just change the combobox to Value List and
list the departments in the Row Source of the combobox
separated by semicolons.
what department the employee works in
(Mechanical,Electrical,Plumbing,etc.). We made a combo box
but it lists every record in the department column and we
have multiple empolyees in one department. How do we have
each department listed only once in the drop down box?
thanks
employees and their associated departments then you need
to add DISTINCT to the SQL query statement in the query
for your combobox.
You could also just change the combobox to Value List and
list the departments in the Row Source of the combobox
separated by semicolons.
We want to have a drop down box for the information on
what department the employee works in
(Mechanical,Electrical,Plumbing,etc.). We made a combo box
but it lists every record in the department column and we
have multiple empolyees in one department. How do we have
each department listed only once in the drop down box?
thanks