text box field won't update

[tennis]

Hello,

I have a form that has 2 fields, City and CityTax. I have a table that lists all the cities with their corresponding tax rates.

I would like to have a drop-down list on the City field where the user can choose the city and then the CityTax Rate is automatically filled in.

For the City field I have a combo box and in the Row Source I have: SELECT DISTINCE table1.City, table1.CityTax From table1

I have ColumnCount = 2 & ColumnWidths = (1;0)

On the On Click event I have:
me.CityTax = me.City.Column(0,1)

The above code does not update the CityTax field. Any help would be much appreciated.

Thanks

 

[jebry]

Hi!

In the After Update for the City combo box put:

me.CityTax = me.City.Column(1)


hth
Jeff Bridgham
bridgham@purdue.edu

 

[tennis]

Thank you for your response.

Hmmm, I added the statement and it still isn't updating the CityTax field.

Any more ideas???

Thanks again