Code for AfterUpdate Property on Combo

[mag]

I have a table called units

with 3 columns unit,location , level

I want the fields UNIT and LOCATION to auto update
on my form.


on my combo box..which is on the Unit field
the "After update "property is coded as:
IUNIT = Units.column(1)
LEVEL = Units.column(2)

my syntax I guess is up the creek


if some one can write exactly what I need
i will be so grateful

thankyou

 

[Mile-O]

You don't need to put any code in at all.

Set the Control source of your controls to the column in your combobox.

i.e

=[Units].[Column].(1)