Hi all...
I have this form based in a single products table. I need some values taken from previous records, so I set 4 combo boxes based on a SQL Statement, with a -select distinct from product-, based each on a different field, of course.
If I run the form with only one CB it works fine; If I try to add one more, I got a "Cannot Acces the selected table" message, and one of the combo boxes just becomes invisible. If I try to run it with 4 CB's I got that message twice and two CB's are gone. To make things even more strange, sometimes two different CB's return the same values! although they are clearly based on a different field.
What gives?
Thanks for your time

Ulises