i know in the back of my mind i know how to do this but...

when i select the suburb in the lookup field i need the table to
automatically update the postcode and state field from the lookup table -
like a vlookup function in excel

help
--
deb