General information
Category:
Forms & Form designer
Title:
No more that one SQL per form???
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only