G
Guest
Hi. I have a report that is called from two different sources: 1.) a form
over a table and 2) from an 'entry' form after which a record set update is
performed to get all the record(s) needed to print the report.
When i do a dlookup when using Forms!Sku!packagingid as the criteria against
my table (packaging with packagingID as key) it works great
but I can't use that when I am calling it from the entry form.
If I try to use just packagingid - not qualified in any way - it just brings
up the first record from the packaging table.
Can you tell me how I need to reference the packaging id that is returned
from the record set vs. the form
and/or is there a way I can tell the report 'when coming from the form, do
this, else do this?
Hope this is somewhat clear.... Thanks
over a table and 2) from an 'entry' form after which a record set update is
performed to get all the record(s) needed to print the report.
When i do a dlookup when using Forms!Sku!packagingid as the criteria against
my table (packaging with packagingID as key) it works great
but I can't use that when I am calling it from the entry form.
If I try to use just packagingid - not qualified in any way - it just brings
up the first record from the packaging table.
Can you tell me how I need to reference the packaging id that is returned
from the record set vs. the form
and/or is there a way I can tell the report 'when coming from the form, do
this, else do this?
Hope this is somewhat clear.... Thanks