I have a form that has a query behind it that queries two tables (tables are one to one relationship). Table one is the main table, table two is why this form was built to update table two with dates that are keyed by the user.
The query is driven using two global variables SR# and CC#. For this example SR# = P2693, and CC# = 0001.
When the form is displayed the Form Header variables look correct. But when something is keyed in the detail section of the form and then tab to the next field, the CC# variable in the header is changing from 0001 to 0000 automatically. I have checked about everything I can think of, but have not been able to determine what is causing this variable to change. Any ideas as to why the variable is changing. Thanks in advance for any help with this Thanks Travis.
The query is driven using two global variables SR# and CC#. For this example SR# = P2693, and CC# = 0001.
When the form is displayed the Form Header variables look correct. But when something is keyed in the detail section of the form and then tab to the next field, the CC# variable in the header is changing from 0001 to 0000 automatically. I have checked about everything I can think of, but have not been able to determine what is causing this variable to change. Any ideas as to why the variable is changing. Thanks in advance for any help with this Thanks Travis.
