Shipping Method and Freight Charge

  • Thread starter Thread starter Ann
  • Start date Start date
A

Ann

I am having a problem with Access automatically inputting the freight
charge when a shipping method is chosen from a combo box. What should I
do?
 
Ann,
Your combobox (ex. cboShipping) should have a list of all (ex.
ShippingMethods) in Col1, and the associated (ex. FreightCharges) in Col2.

Use the AfterUpdate event of the combobox to set the value of
FreightCharges. Use this code...

[FreightCharges] = cboShipping.Column(1)

(In VB code, the first column in a combo box is numbered 0 then 1 then 2..
etc... so Shipping Method is in Col0, and FreightCharges is in 1)
hth
Al Camp
 
Could you explain how your doing it and what is going wrong? layouts and code
are helpful to find your problem.
 
I am trying to create a form that will automatically insert and
calculate the freight charge when the shipping method is chosen. Should
I be using an excel spreadsheet to input the info?

Basically I have items of the same weight, so 2 item = 14 oz.; UPS
Ground=$2.50 for >1b.; I need this to be automatically updated under"
Freight Charge" when product "number" and "shipping method" are input.
 
Thanks, Al

I tried putting in the code, but it returned an error msg about not
finding that macro.

Joy
 
Back
Top