Delivery Costs & Location Form?

[circlestech]

Hello,

I'm setting up a delivery cost and location form. What i need this form to do is say i select Guildford for delivery i need the delivery cost text box below to say £12.50 without manually looking up the costs for that area and if it was Farnham then £24.00. What is the easiest way of doing it?

Thanks

 

[ShaneMan]

Hello,

I'm setting up a delivery cost and location form. What i need this form to do is say i select Guildford for delivery i need the delivery cost text box below to say £12.50 without manually looking up the costs for that area and if it was Farnham then £24.00. What is the easiest way of doing it?

Thanks

Hello circlestech,

Is the 'delivery cost text box' in the same table as 'location'? If it is then I would think you could make the location into a cboBox and have two fields in it's control source. Location and DeliveryCost, then when a choice is made in the Location cboBox put code in it's AfterUpdate event that would autofill the 'delivery cost text box' with the value in the second column of the Location cboBox.

HTH,
Shane

 

[circlestech]

Hello Shane,

Both DeliveryCost & DeliveryLocation are in the same table what code would i require putting the afterupdate to make this work?

Thanks
Ben

 

[ShaneMan]

Hello Shane,

Both DeliveryCost & DeliveryLocation are in the same table what code would i require putting the afterupdate to make this work?

Thanks
Ben

If DeliveryCost is the second column in your cboBox then this should work:

Me.DeliveryCostTextBoxName = Me.cboBoxName.Column(1)

HTH,
Shane