G
Guest
I'd like to put in a If..Then..Else statement on my form. On the
Postcode_After Update event I want Access to 'read' the first two letters of
the postcode and depending on what they are, return the name of the closest
warehouse in the next field.
So, in words, If the first two letters of the postcode are AB or B or BB or
BD or BL etc then the Warehouse field should read Kendal Else if the first
two letters of the postcode are AL or CB or CM or CO or CT etc then the
Warehouse field should read Rushden Else the Warehouse field should read
Bristol.
Any comments and help appreciated.
Postcode_After Update event I want Access to 'read' the first two letters of
the postcode and depending on what they are, return the name of the closest
warehouse in the next field.
So, in words, If the first two letters of the postcode are AB or B or BB or
BD or BL etc then the Warehouse field should read Kendal Else if the first
two letters of the postcode are AL or CB or CM or CO or CT etc then the
Warehouse field should read Rushden Else the Warehouse field should read
Bristol.
Any comments and help appreciated.