Auto State and Postcode from Suburb

[Chief]

Hello,
(Access 2010)
I have a several forms with an address field, Suburb Field, State Field and Postcode Field.

I have the Suburb Field using a combo box to Look up a table which has the suburbs, States and Postcode Data.
I want the State and Postcode fields to autofill AND complete the data in the relevant table.

I have written the following code to the Suburb field On Click

Private Sub Suburb_Click()
State = Suburb.Column(2)
PCode = Suburb.Column(3)
End Sub

For some reason it is working on one form but not on any others.??
Any suggestions please?
Thank you

 

[John Big Booty]

Perhaps the sample here will give you some pointers.

 

[Chief]

Thats full on! lol
Thank you