Auto update other fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
Back
Top