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!
Lynette
ltillner At yahoo DOT com
©2001 Lynette Tillner |
