Get data from a cascading combo to update another field

[Guernsey Gaz]

Hi All
I have a form frmClientsDetails based on a table tblClientsDetails. On the form I have an unbound cascading combo which allows me to select a Country from a Country_City table, this in turn changes the cboCity Combo list to reflect the Cities of that Country and I can choose the city. That City then appears in the City field in the tblClientsDetails.

In the tblClientsDetails I also have a field called Country, how can I get the field to update with the choice I make in the unbound combobox?

All help is greatly accepted.

Gaz

 

[boblarson]

Hi All
how can I get the field to update with the choice I make in the unbound combobox?

The easy way? Bind the combo box to the field.

 

[Guernsey Gaz]

Hi Bob
How do I do this?
I tried in the properties box to = cboCountry but it dosn't update the table with the chosen country

I'm a newby in too deep

 

[boblarson]

in the properties box of the combo box, go to Control Source and select the field from the dropdown.

 

[Guernsey Gaz]

Thanks Bob
Works a treat, and have tipped your scales
Gaz

 

[boblarson]