Need a DLOOKUP on Form to save in field on Table

[KEKeogh]

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

 

[isladogs]

Not quite sure how you are using your DLookup but the syntax was wrong.
Try this

=DLookUp("[FMCC Rep]","[Client_Contact_Info_Main]","[Company_Name] = '" & [Client] & "'")

 

[KEKeogh]

Thank you so much.

It still doesn't save to the table field but I can make a query to work with now.

Guess that syntax error was enough that I couldn't even do that.

Kathie

 

[isladogs]

Either use an update query or set the field value equal to the dlookup on your form.
The dlookup shouldn't be in your forms record source