dlookup fields in forms are blank in report

S

stillcrazee

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?
 
F

fredg

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?
 
S

stillcrazee

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.
 
Top