I have two tables in an Access 97 database, Employee and State_Postcodes. The Employee table has a field called Suburb-Town which is where the Employee lives.
On a data entry form I have a DBCombo that reads in all the valid suburbs/towns from the State_Postcodes tables which updates the field Suburb-Town in Employee.
I have two data controls, one for navigating through Employee and the other, a hidden one for State_Postcodes (unsure if this is correct).
I have two 'unbound' text boxes called txtPostcode and txtState respectively.
I am using Visual Basic 5.0 Enterprise Edition
Question: When the user selects a Suburb/Town from the combo box, I want the corresponding values from the State_Postcodes table to be automatically pasted into the correct textboxes *AND* the Suburb-Town field in the Employee table to be updated appropriately. How?