S
Skeletor
Hi. I hope somebody can help with this.
I am trying to modify the Northwind db. I have changed the Customer Details
form so that when I type in a Suburb name in the combo box "Suburb", the
"State" and "Post Code" List boxes fill with the correct data.
I have created a new table called "Pcode", that contains a Unique ID,
Suburb, State, Post Code columns.
The "Suburb" combo box selects the correct name as you type, but regardless
of what code I put in the other two combo boxes; "State" and "Postcode", I
cannot get it to populate properly.
I have tried every suggestion that is listed on this forum, but nothing
seems to work. I am a very basic Access user and therefore fairly unfamiliar
with the steps one needs to do to make this happen.
Could someone please outline what needs to be done from start to finish (or
write the code so I can copy it), what, if any table relationships are
required and what is needed to store that info in the "Customers table.
Any help would be greatly appreciated.
Mike
I am trying to modify the Northwind db. I have changed the Customer Details
form so that when I type in a Suburb name in the combo box "Suburb", the
"State" and "Post Code" List boxes fill with the correct data.
I have created a new table called "Pcode", that contains a Unique ID,
Suburb, State, Post Code columns.
The "Suburb" combo box selects the correct name as you type, but regardless
of what code I put in the other two combo boxes; "State" and "Postcode", I
cannot get it to populate properly.
I have tried every suggestion that is listed on this forum, but nothing
seems to work. I am a very basic Access user and therefore fairly unfamiliar
with the steps one needs to do to make this happen.
Could someone please outline what needs to be done from start to finish (or
write the code so I can copy it), what, if any table relationships are
required and what is needed to store that info in the "Customers table.
Any help would be greatly appreciated.
Mike