I can't code worth a damn. Problem: Tabbing past the last tab stop on my form causes multiple invalid records in a child table.
Table-tbl_jobsdetail.
Form-frm_svcorderentry1 based on table.
Trace: Created by just tabbing through the order.
Event: :frm_svcorderentry1 "OnActivate"
Event: :frm_svcorderentry1:Save "CanArrive"
Event: :frm_svcorderentry1:MEMO "CanDepart"
Event: :frm_svcorderentry1:MEMO "OnDepart"
Event: :frm_svcorderentry1:Save "OnArrive"
Event: :frm_svcorderentry1:Cancel "CanArrive"
Event: :frm_svcorderentry1:Save "CanDepart"
Event: :frm_svcorderentry1:Save "OnDepart"
Event: :frm_svcorderentry1:Cancel "OnArrive"
Event: :frm_svcorderentry1:HOW_MANY "CanArrive"
Event: :frm_svcorderentry1 "CanSave"
Event: :frm_svcorderentry1:Cancel "CanDepart"
Event: :frm_svcorderentry1:Cancel "OnDepart"
Event: Table( TBL_JOBSDETAIL ) "CanSaveRecord"
Event: Table( TBL_JOBSDETAIL ) "OnSaveRecord"
Event: :frm_svcorderentry1:Cancel "OnArrive"
Event: :frm_svcorderentry1 "OnSave"
Event: :frm_svcorderentry1:Cancel "CanDepart"
Event: :frm_svcorderentry1:Cancel "OnDepart"
Event: Field( TBL_JOBSDETAIL->HOW_MANY ) "CanEditField"
Event: Field( TBL_JOBSDETAIL->HOW_MANY ) "OnEditField"
Event: :frm_svcorderentry1:HOW_MANY "OnArrive"
Event: :frm_svcorderentry1:HOW_MANY "CanDepart"
Event: :frm_svcorderentry1:HOW_MANY "OnDepart"
Event: Field( TBL_JOBSDETAIL->HOW_MANY ) "CanEditField"
Event: Field( TBL_JOBSDETAIL->HOW_MANY ) "OnEditField"
Event: :frm_svcorderentry1:HOW_MANY "OnArrive"
Event: :frm_svcorderentry1:HOW_MANY "CanDepart"
Event: :frm_svcorderentry1:HOW_MANY "OnDepart"
Event: Table( TBL_JOBSDETAIL ) "CanEnterRecord"
Event: Table( TBL_JOBSDETAIL ) "OnEnterRecord"
Event: :frm_svcorderentry1 "OnEnter"
Event: :frm_svcorderentry1:HOW_MANY "CanArrive"
Event: Field( TBL_JOBSDETAIL->HOW_MANY ) "CanEditField"
Event: Field( TBL_JOBSDETAIL->HOW_MANY ) "OnEditField"
Event: :frm_svcorderentry1:HOW_MANY "OnArrive"
Event: :frm_svcorderentry1 "OnDeactivate"
How to generate problem:
Open From: frm_openjobs 'Based on set set_jobentry
On browse of form: Double-click any parent record. 'The onrowdoubleclick envent of the browse will open the frm_svcorderentry1 form, creat a new child record, and populate several fields.
There are only five tab stop fields. If the user tabs past the last tab stop "5" three ugly and unwanted records are created in the tbl_jobsdetail.
I either want to prohit the user from tabbing past the last tab stop or allow the tab stop without the mess.
Please help!
Table-tbl_jobsdetail.
Form-frm_svcorderentry1 based on table.
Trace: Created by just tabbing through the order.
Event: :frm_svcorderentry1 "OnActivate"
Event: :frm_svcorderentry1:Save "CanArrive"
Event: :frm_svcorderentry1:MEMO "CanDepart"
Event: :frm_svcorderentry1:MEMO "OnDepart"
Event: :frm_svcorderentry1:Save "OnArrive"
Event: :frm_svcorderentry1:Cancel "CanArrive"
Event: :frm_svcorderentry1:Save "CanDepart"
Event: :frm_svcorderentry1:Save "OnDepart"
Event: :frm_svcorderentry1:Cancel "OnArrive"
Event: :frm_svcorderentry1:HOW_MANY "CanArrive"
Event: :frm_svcorderentry1 "CanSave"
Event: :frm_svcorderentry1:Cancel "CanDepart"
Event: :frm_svcorderentry1:Cancel "OnDepart"
Event: Table( TBL_JOBSDETAIL ) "CanSaveRecord"
Event: Table( TBL_JOBSDETAIL ) "OnSaveRecord"
Event: :frm_svcorderentry1:Cancel "OnArrive"
Event: :frm_svcorderentry1 "OnSave"
Event: :frm_svcorderentry1:Cancel "CanDepart"
Event: :frm_svcorderentry1:Cancel "OnDepart"
Event: Field( TBL_JOBSDETAIL->HOW_MANY ) "CanEditField"
Event: Field( TBL_JOBSDETAIL->HOW_MANY ) "OnEditField"
Event: :frm_svcorderentry1:HOW_MANY "OnArrive"
Event: :frm_svcorderentry1:HOW_MANY "CanDepart"
Event: :frm_svcorderentry1:HOW_MANY "OnDepart"
Event: Field( TBL_JOBSDETAIL->HOW_MANY ) "CanEditField"
Event: Field( TBL_JOBSDETAIL->HOW_MANY ) "OnEditField"
Event: :frm_svcorderentry1:HOW_MANY "OnArrive"
Event: :frm_svcorderentry1:HOW_MANY "CanDepart"
Event: :frm_svcorderentry1:HOW_MANY "OnDepart"
Event: Table( TBL_JOBSDETAIL ) "CanEnterRecord"
Event: Table( TBL_JOBSDETAIL ) "OnEnterRecord"
Event: :frm_svcorderentry1 "OnEnter"
Event: :frm_svcorderentry1:HOW_MANY "CanArrive"
Event: Field( TBL_JOBSDETAIL->HOW_MANY ) "CanEditField"
Event: Field( TBL_JOBSDETAIL->HOW_MANY ) "OnEditField"
Event: :frm_svcorderentry1:HOW_MANY "OnArrive"
Event: :frm_svcorderentry1 "OnDeactivate"
How to generate problem:
Open From: frm_openjobs 'Based on set set_jobentry
On browse of form: Double-click any parent record. 'The onrowdoubleclick envent of the browse will open the frm_svcorderentry1 form, creat a new child record, and populate several fields.
There are only five tab stop fields. If the user tabs past the last tab stop "5" three ugly and unwanted records are created in the tbl_jobsdetail.
I either want to prohit the user from tabbing past the last tab stop or allow the tab stop without the mess.
Please help!
Comment