dlookup fields in forms are blank in report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have some fields in a FORM that are populated with using dlookup. When I
reference the fields in my REPORT, all of those fields are blank. Hopefully,
this is something easy that I just don't know.

Any help, please?
 
I have some fields in a FORM that are populated with using dlookup. When I
reference the fields in my REPORT, all of those fields are blank. Hopefully,
this is something easy that I just don't know.

Any help, please?
Click to expand...

The form must be open when the report is run.
How are you referencing the form control in the report?
 
fredg, sorry it has taken so long to get back to you. I am sorting my report
by material. I have fields in my report where I type information in the
form, and those all come out okay. Those fields are - vendor, number of
units, actual cost. It is the calculated and lookup fields that are right in
the form, but when I print the report, they are blank. Those fields are -
unit of measure, standard cost per unit, standard cost, and
favorable/unfavorable.

To answer your question as to how am I referencing the form control in the
report, I have tried various things. For instance, I just left the field
name in the detail area, and I also tried using a formula in the detail such
as for standard cost, I use [standard cost per unit]*[number of units].
Thanks for your time.
 
Back
Top