Hi all!
Need some help. I have the below DLOOKUP on a form in it's Control Source property and I need it to update the [Commission Due To] field in the "Invoice Master" Table with that same value.
=DLookUp(" [Client_Contact_Info_Main]![FMCC Rep] ","[Client_Contact_Info_Main]","[Client_Contact_Info_Main]![Company_Name] = [Client] ")
Thanks for any help.
Kathie
Need some help. I have the below DLOOKUP on a form in it's Control Source property and I need it to update the [Commission Due To] field in the "Invoice Master" Table with that same value.
=DLookUp(" [Client_Contact_Info_Main]![FMCC Rep] ","[Client_Contact_Info_Main]","[Client_Contact_Info_Main]![Company_Name] = [Client] ")
Thanks for any help.
Kathie