On a Deposit, when a user clicks F3 on the keyboard to get a new header, the Account Type on the Deposit Line is set to Customer. I would like to modify the code to default this field to G/L Account. I assume this is happening in the OnInsert trigger of either the Deposit Header table or the Deposit Line table, but have been unable to use anything that affects this default to Customer. Does anyone know what makes this happen?
In the OnNewRecord trigger of the Deposit Subform I inserted “Account Type” := 0; and this seems to work. Any downside to doing this?
In the Deposit Line table INIT value for the Account Type field is “Customer”. If you remove the INIT Value then it will roll back to the First Option value for this field, which is “G/L Account”.