Autopopulate field

[nancym]

Hi, I have a table that has included 2 fields, Location & rate.
I have a form that has these two fields in them. The Location is a drop down list, and I would like the rate to autopopulate when a location is chosen.
_ ComboName.Column(2) does not work.
Any suggestions?


Thanks Nan

[RuralGuy]

The Column() value is zero based so (2) would be the 3rd column. Does that help?

[nancym]

The Column() value is zero based so (2) would be the 3rd column. Does that help?

Hi, no I get nothing, Thanks anyway

[RuralGuy]

Do you have 3 columns of data in your ComboBox?

[nancym]

Do you have 3 columns of data in your ComboBox?

Hi, I have the ID, Location, and Rate.
I have tried =CcomboName.Column(1) then (2) then (3)
I only get a return of the location for the rate when I use the (1)
Nan

[RuralGuy]

What do you have on the Format tab ofn the Property sheet for the cbo for ColumnCount and ColumnWidths?

[nancym]

What do you have on the Format tab ofn the Property sheet for the cbo for ColumnCount and ColumnWidths?

column count=2 width=0";1"

If I put in (1) in the Combo Name it gives me the Location back ex. Boston, but not the rate associated with it.

[RuralGuy]

Change the ColumnCount to 3 and see what happens when you use .Column(2).

[nancym]

Change the ColumnCount to 3 and see what happens when you use .Column(2).

Hi, That didn't do anything, I made a copy of the table, then re-inserted the fields from the table, changed the format of rate to currency, and now it works. Thanks you for your help. how do I mark this as solved?

[RuralGuy]

Thank you for your help. how do I mark this as solved?

It is under Thread Tools at the top of the thread.

[mejia.j88]

you should create a query from your table that only includes the info you want,
i.e. location and rate.

use this qry as then row source for location.

then:

Private Sub LOCATIONFIELDNAME_AfterUpdate()
Me.RATEFIELDNAME = Me.LOCATIONFIELDNAME.Column(1) 'rate
End Sub

make sure rate is the second column of your query.

does this help?