Invoice - adding new fields

  • Thread starter Thread starter jwrnana
  • Start date Start date
J

jwrnana

I am using the invoice format provided with Order entry database. I need 2
fields to be added. One for the serial number of the product and the other
is Line item number for each item ordered; i.e. -- 1. tractor
Serial # 123456
2. lawn mower 789101
3. weed eater XRY22

I put a new item in the OrderDetail and Ordersubform for both line item
number and serial number. The line number and serial number work fine when
entering information on the form; however, when it goes to the invoice, I
get the error for line number "#NAME?" and for serial number "#ERROR".
Also, when I want to print the invoice I am asked for the OrderID parameter.
If I return without entering information, I can see the invoice; however, I
have the errors as listed above.

Joy Rose
 
The invoice was already built -- source comes from Orders, OrdersID,
Customers, Products, Shipping Method, and Employee tables. Filter =
([OrderID]=Forms![Orders by Customer]![Orders by Customer
Subform].form![OrderID])

Do I need to add to EACH of these tables the 2 new fields? What source do I
need to use for the properties? On the Line# I have used
=[Forms]![OrderDetailSubform]![LineItem] This is where I get #NAME?
error.

Thanks.
 
Back
Top