How to get a query result into a form

[Keith]

I have a query the SQL view is
SELECT Max([customerID]) AS Total
FROM tblCustomer
WHERE (((Left([CustomerID],3))=[forms]![frmNewCustomer].[txtFirst3]));
I run the query and the result is
Total
BIS007
How do I get Total into a text box on my form so that I can use it?

 

[MStef]

Try with DLOOKUP function.

 

[Ron_dK]

the result is
Total
BIS007

How do I get Total into a text box on my form so that I can use it?

Assuming that the total is a "field" in your query grid, create a textbox on your form and ensure that the source property is set to Total.

Hth