Hi, This is a strange one - I have a recordset bound to my page, 'UCust'
containing a list of customer names. It uses the DISTINCT SQL statement to pull
out the unique names of customers in a table. When I test the binding, it
correctly shows: Customer1 Customer2 Customer3 However, I have a dropdown on
a form which I've told to display this dynamic data, but instead of the three
customers, it only shows Customer1 - the other two are not in the list.
What's really odd is that I've done exactly the same on another page and it
works correctly. I've even copied the exact same code from my working dropdown
to the one that doesn't work. The recordset is also copied/pasted from the
working page - so the dropdown is absolutely identical - only one works, the
other doesn't!! Does anyone know where I should go from here? What else could
cause this? Thanks in advance, wildwildwebs