I hope someone out there can help me. I am A new user of
access and have learned access by trial and error.Here is
my problem. I have used an existing database that access
provides called Order Entry , and I have added a table
called Used at, Because We often Send products to one
company that distributes them to other places and I need
to keep track of where they were used. So in the order
detail form I have added a drop down list, so that I can
click on where it was used. All is fine and dandy there.
And when I pull up the order it shows it there. My problem
is , that there is a report called invoice, and I have the
option to print the invoice after I am done entering the
order. But I can not get the information in the drop down
list to print on the invoice. no matter what i've done to
get it to print, with other information ,is working. So
any help with this would be very appreciated. Most of the
time I get this error #Name? How do I get it into the
field list for the report?
.
access and have learned access by trial and error.Here is
my problem. I have used an existing database that access
provides called Order Entry , and I have added a table
called Used at, Because We often Send products to one
company that distributes them to other places and I need
to keep track of where they were used. So in the order
detail form I have added a drop down list, so that I can
click on where it was used. All is fine and dandy there.
And when I pull up the order it shows it there. My problem
is , that there is a report called invoice, and I have the
option to print the invoice after I am done entering the
order. But I can not get the information in the drop down
list to print on the invoice. no matter what i've done to
get it to print, with other information ,is working. So
any help with this would be very appreciated. Most of the
time I get this error #Name? How do I get it into the
field list for the report?
.