invoice

[Guest]

I would like to create an invoice that has a ship to bill to and shipped from
with each having different addresses. can some one steer me in the correct
location to find help on doing this.

 

[Arvin Meyer [MVP]]

I would like to create an invoice that has a ship to bill to and shipped
from
with each having different addresses. can some one steer me in the correct
location to find help on doing this.

In your customers table you will need to decide if there is a single
ShipTo/BillTo for each, or that they can have many of either or both. If the
answer is only 1 of earch per customer, a single table is enough, if there
can be multiples, you need 2 tables (1 for the CustomerID, name, etc. and 1
for the multiple locations). Let's assume a single set for now. Add fields
for both ShipTo and BillTo addresses in your table.

Use a combo box to display on the form when you select your Customer. Add
all the columns in your combo's data source that you will need in BillTo and
ShipTo

Then in the Combo's AfterUpdate event, use something like:

Sub cboCustomerID_AfterUpdate()
Me.BillToAddress = Me.cboCustomerID.Column(2)
Me.BillToCity = Me.cboCustomerID.Column(3)
Me.BillToState = Me.cboCustomerID.Column(4)
' ...
Me.ShipToZip = Me.cboCustomerID.Column(9)

End Sub

 

[Guest]

I have another question for you:
I am trying to print one invoice at it times by Invoice Number, but when I
try to "create parameters" using queries In try to created with the Invoice
Number field. it show the followoing "Undifined function Number in
expression.
what undifined function and what expression
in the parameter dialog I typed the following
InNumber Interger

then in the Criteria I typed number ([Invoice Number]) = [inNumber]

Can you help or please direct me over to someone that could help.

Thank you
Luis

Please reply to my email.

(e-mail address removed)