Shipping Method and Freight Charge

[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?

 

[AlCamp]

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

 

[Guest]

Could you explain how your doing it and what is going wrong? layouts and code
are helpful to find your problem.

 

[Ann]

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.

 

[Ann]

Thanks, Al

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

Joy