1 table - 2 combo box. Want column 2 from 1st combo

[yimi]

I have a table CG Information. In this table I have a field CGCity which uses a combo box to select the field City from another table. (the region field is also part of the combo box but has a width of 0" so its not shown. It's column2) The table the combo box is using is called Region and contains fields City and Region.

In the CG Information table I also have a field called CGRegion. I would like to have the CGRegion do any one of the following...

* have a pulldown that shows the city and region where I can select by City but have the region populate.

*Automatically input the CGRegion based on the CGCity

or
* have a pulldown that only shows the region related to the CGCity in the first combobox.

I had created an append query to run which works fine. But the person I'm creating this for wants the region field to update in the table.

I hope this makes sense to someone. I would really appreciate any help. THANKS

 

[cmmrfrds]

Column 2 in the Region combobox can be referenced like below.
dim var as string
var = Me.Region.column(1) '- zero based