<i><font color="#663300">Hi!
I have a one to many form with NO Bizobjs (one version). It uses all SQL calls to fill a combobox and 2 related children list boxes. The form loads and fills the list boxes correctly on selection of the first desired parent from the combobox. However, when an interactive change is made, and the list boxes are Requeried to load data relating to the changed parent, I get this error (2 versions one for each list box):
Error # 1806
Message: SQL Column 'LCCONTACTID' is not found
Code: SQL Column 'LCCONTACTID' is not found
Method: Requery
'LCCONTACTID' is the variable set up at the beginning of the interactivechange process and it is used in the where statement to match the listbox records to their parent.
when I click "continue" on the error, the form refreshes to the correct children for the newly selected parent.
I'm at a loss as to how to fix this one!
THanks!
</font></i>
I actually solved this.... it was caused by having the requery() method in tooo many places. This newbie tends to overwork her methods in an attempt to make a form "work" I had requery in the interactivechange(), in the init() AND in the valid() WAY too much work for the poor little form and it was stumbling all over itself! That's why even though I'd get errors, eventually something worked when I kept saying "continue." I have since removed the bad code and whittled the requery() down to ONE appropriate place. Unfortunately, I forget which method was the correct place to put that code.
Lynette
ltillner at yahoo DOT com
©2001 Lynette Tillner |
