DLookup to bring report totals into form controls

[CW]

I have a report that counts and sums the number and value of our bookings
each month. Those values are in Textbox19 and Textbox21 in the footer of
rptMonthlyBookings.

I'm trying to get those values into controls on a form, using DLookup, and
keep getting Error as the result.

Could someone kindly confirm the correct structure of the DLookup expression
for this?

Many thanks
CW

 

[Maurice]

Place the dlookup in a textbox not in the footer but in a additional section
of the form. Insert a page footer and try it in there. Also show us the
dlookup you are using maybe there's something wrong with it and we can take a
look at it.

 

[CW]

No the dlookup textboxes aren't in a footer, that's not what I said.
It's the source textboxes i.e. the Sum and Count textboxes that are in a
footer, (the footer of the report).
I want to pull the values from there into textboxes that are sitting in the
Detail section of a form.

 

[Maurice]

My apologies misread and misunderstood the question.

What is the DLookup statement what you are using now what is causing the
error?

Syntax should be:

=Dlookup("lookupfield","lookuptable","lookup variable")