Help !!! I have creatd a new subform (and new table) that sits on the Sales Header invoice on a new tab. The form link I have used is: Adv. Inv. No.=FIELD(No.),Customer No.=FIELD(Sell-to Customer No.) This links the form okay for the Inv. No., but does not bring through the Customer No. However, if I come back off this tab and then back onto it, the field is filled. Any suggestions, as I need this as soon as the subform appears for ship to addresses ??
Set the Property PopulateAllFields=Yes on the subform, that should fix it. Lars Strøm Valsted Head of Project and Analysis Columbus IT Partner A/S www.columbusitpartner.com
Put the code ‘Currform.update’ in the trigger “oN AFTER VALIDATE” of the control “sell-to customer no” in the form
Result!! The forum has come good again. The solution that I have used is the one supplied by Fabrice, but Thanks to you both. Dean