Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

adding a field to an invoice ( Easy question)

Status
Not open for further replies.

artdept

Technical User
Jun 3, 2002
8
US
i am trying to print an invoice for our customers and want to add a "description" field to it. I went into design view and added the text box, but when i preview the invoice, it only shows the text, not the actual description info that was entered on the order.
I know this is easy to solve.......
Thanks in advance.
 
artdept, check the control source property of the text box, it should correspond to a field in a table or query or it should be an expression. What exactly do you mean by "it only shows the text, not the actual description..."?

Regards,

Henry
 
I agree completely with Henry. What you are describing sounds like the recordsource is setup incorrectly, but your error description is somewhat ambiguous, so clarification would be helpful to further help in this problem. James Goodman
j.goodman00@btinternet.com
 
Sorry guys for being vague. The following is how we have our order form set up. Info in ( ) is the entered data by the employee.
Product (T-shirt) Description (50/50) Quantity (250) Cost (0.00), etc...

Now, when I print the invoice it list:
Product Description QTY Cost etc...
T-shirt 250 0.00

The description field is blank and doesn't list the 50/50 info
So I went into design view and selected the PROPERTIES of this field. I went to the control source line, but don't know what to assign to it.
Basically all I want is for the information entered by the employee into the description field to show up on the invoice.

I hope this is a little more clear. Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top