>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
Make sure you have different CURSOR targets of the SQL statement in each CB.
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net
CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."