Invoice Form

  • Thread starter Thread starter Sal
  • Start date Start date
S

Sal

Created form (invoice).
Currently using combo box to allow selection of part#,
description, and unit price.
Have ext price field calculate qty field x unit price
field.

To save on user having to select all data pertaining to
specific part, how do I make work so when user selects
part#, the description and unit price pre-fills and I
still have calculation feature?

Thanks

Sal
 
Jackie,

Thanks for the help.
The calcualted field only applies on the form - unbound
field.

Sal
-----Original Message-----
First, your Part# combo box will need to have the Description and Unit Price
in the columns (they do not have to show, width would be zero but they need
to be included in the column count). Then, on the After Update event of the
Part# field put the following code:
Me.Description = Part#.Column(1)
Me.UnitPrice = Part#.Column(2)

(where column 1 actually represent the second column, numbering starts at
zero).

Next, I would not recommend saving a calculated amount in a field, like your
extended amount field. Instead just show the calculated field on forms,
reports, etc. It is just opening up doors for problems if the field is not
updated.

Having said that, if you choose to continue with the extended price field,
you would need to put the following code on the After Update event of the
quantity field:

Me.ExtendedPrice = [Qty] * [UnitPrice]

Hope this helps.

Sal said:
Created form (invoice).
Currently using combo box to allow selection of part#,
description, and unit price.
Have ext price field calculate qty field x unit price
field.

To save on user having to select all data pertaining to
specific part, how do I make work so when user selects
part#, the description and unit price pre-fills and I
still have calculation feature?

Thanks

Sal
Click to expand...
.
Click to expand...
 
Back
Top