I'm putting together a form. I want to use the form in both Enter and Edit mode. I have a column for ControlNum and a column for CustCode. When the user enters the ControlNum, I want to look up the expected CustCode in another table and set the CustCode column to this value. I then want the user to be able to change the CustomerCode value if necessary.
I believe in prior versions, the lookup would happen only when the variable or column on which it depended changed. That is, the expression CustCode = CustCode IN ControlTbl WHERE ControlNum = ControlNum would only evaluate when the ControlNum column on the form changed. Now, it evaluates as soon as a I type over the CustCode value, and the CustCode value gets set back to the default from the ControlTbl. Question: Am I remembering correctly the way it used to work? Has it changed or not changed in version 7? Is there a setting I can switch to change it back to the old behavior? Or a work around? -- Larry
