I have a form that I am using with the ENTER USING command. This form is also used with the EDIT USING command.
I want to pass in a default value for the EmpID column. Before calling this form, I put the value into the variable fDQREdit_EmpID. I expect to be able to set my column with the form expression: EmpID = (IFNULL(EmpID, .fDQREdit_EmpID, EmpID)) but it isn't working. EmpID seems to stay NULL. More info: I know that the value fDQREdit_EmpID is set properly, because I placed it on the form and you can see the value. I have tried including a RECALC VAR in an entry EEP on the form, without any change in result. I tried changing my IFNULL expression to the equivalent IFEQ expression with no change in result. In this case, I cannot pre-enter the row in the table and then use EDIT USING, I must use ENTER USING. Any suggestions much appreciated. -- Larry
