Query Results Into Textbox

[Badeye]

Hi Guys,

I'm not sure what i'm missing here. I have a query but want the results to appear in a textbox. I believe the best way is to do a DLookup which i have tried but it the problem im getting is that its just says calculating in the bottom left until i click on the textbox and then the value appears. Surely this is not right?

Any tips

I'm using Access 2007