Auto update other fields

[Guest]

I have a customers form with the fields
CustomerID, Customer, Address, Suburb, State, Postcode
I have a table that holds the states and a table that holds the suburbs and
postcode

What i want to be able to do is to choose the state in the combo box i have,
that will filter the suburbs for that state and then when i go to the suburbs
combo box and select a suburb it will automatically fill in the post code
that matches the suburb.

Is this possible?

thanks for your help in advance
Lee

 

[Guest]

Yes, this type of auto update of fields is entirely possible and is done all
the time.

However, you might want to rethink your entry and auto fill process a
little. If you have a table that has the suburb, state and zipcode then you
could have a combo box that would provide the ability to enter and/or select
the zipcode and then have the state and suburb filled in.