Using Dlookup in a form

[buddyleee5]

I have 3 separate tables- Tbl_Customers, Tbl_CustomerInvoices, Tbl_CustomerPayments. All three tables are linked through the field "Customers" which is the customer's "Last Name, First Name". I have set up the fields in the invoice and payment tables to reference the customer table for the list of customers.

My issue now is that I am creating an invoice and I need to use the Dlookup function to display the hourly billing rate for the customer that is listed in the Tbl_Customers on the form. I created a text box and entered in this function: =DLookUp("[Hourly Billing Rate]"," Tbl_Customers","Tables![Tbl_Customers]![Customer] =" & "Forms![Frm_CustomerInvoices]!Customer")

That is the formula as I have gotten from multiple help sites and tutorials, but it continues to return "#error" but I have no idea why. Any help is apprecatiated! Thanks!

 

[Taruz]

=DLookUp("[Hourly Billing Rate]"," Tbl_Customers","Customer=" & [Customer])

Hi..

Try this way..

 

[buddyleee5]

=DLookUp("[Hourly Billing Rate]"," Tbl_Customers","Customer=" & [Customer])

Hi..

Try this way..

Still returning an error message.. I have tried just about every way I can think of and I can't figure the issue out

 

[Taruz]

Customer's field text data type, try this..:

=DLookUp("[Hourly Billing Rate]","Tbl_Customers","Customer='" & [Customer] & "' ")

 

[buddyleee5]

Customer's field text data type, try this..:

=DLookUp("[Hourly Billing Rate]","Tbl_Customers","Customer='" & [Customer] & "' ")

I'm so happy I want to cry! Thank you!