Question Linking postcodes, suburbs, states together. Combo box?

[wotamelon]

Hello, thanks for reading this.

I have a database full of postcodes, suburbs, and states (tlb_SUBURBS). They all correspond with one another.

On the main form (frm_MAIN), I need to create an automatic tab tab system, where i type in first letter of the suburb, then its relavent post codes and its state will show up in the next two field txt boxes.

How do I do that?

I have made a COMBO_suburb, then how do I link postcodes and states with it? and in what format should POSTCODES and STATES be in? List? COMBO? TEXT FIELD?


Confused

 

[MStef]

Look at "DemoComboB3A2000.mdb" (attachment, zip).
Open Form1 and try. I think it is what you need.

 

[wotamelon]

Look at "DemoComboB3A2000.mdb" (attachment, zip).
Open Form1 and try. I think it is what you need.

But do these data (column 2, 3, 4) gets stored in a table when its displayed?

What I want to do is...

I select 'SYDNEY' then '2000' comes up and 'NSW' comes up. However '2000' and 'NSW' data gets stored in POSTCODE and STATE in Tbl_SUBURB.

Thanks

---------------------------------------------------
In case of any confusion, what I am trying to say is that on my frm_MAIN, there are fields which include: NAMES, ADDRESS, 'SUBURB', 'POSTCODE', 'STATE', 'PHONE NUMBER' etc.
I want to be able to enter in the client's details in this frm_MAIN, then when i get to 'SUBURB' field I press TAB on keyboard and TAB again to skip STATE and POSTCODE. But I wish that those displayed STATE and POSTCODE data can be stored in the Client's database table

 

[John Big Booty]

Check the sample posted here, it has AU postcodes

 

[MStef]

You don't need the same data in two tables.