MS-Access using Dlookup to pull results from query into textbox on form

Question

I am very new to access and I am using the Dlookup function to pull the results from a query into a text box to appear on a form. I have the following expression in the Data Control Source field for the text box and it is pulling in the very first result from the query. =DLookUp("SumOfSales","qTtlSalesbyComp","Company = Company")

I need it to act as a vlookup and match the Company in the query to the Company in the Company text box and pull the SumofSales that corresponds. Any hep would be greatly appreciated.

Answer 1

If Company is text:

=DLookUp("SumOfSales","qTtlSalesbyComp","Company = '" & Company & "'")

If it is numerical:

=DLookUp("SumOfSales","qTtlSalesbyComp","Company = " & Company )

Answer 2

I just could not seem to get the Dlookup to work. I ended up using subforms to pull in the query results. I believe this ended up being a much cleaner way of executing what I wanted.