Populating form fields based on another field

[Alex]

I have a table called RLS w/ a multiple value primary key, [rcdloc] & [desk].
The RLS table is my forms record source. I have a combo box showing both
the rcdloc and desk fields. If I make the bound combo box column [rcdloc]
the how can I populate the [desk] field in my form immediately, based on the
[rcdloc] the user picked?

Thanks

 

[Ofer]

On the after update event of the rcdloc combo, write the code
me.desk = me.rcdloc.column(1) 'Assuming that the desk is the second column
in the combo, it starts with 0

Or if you are not storing the desk value in a table, then you can write in
the ControlSource Property of the desk field
=[rcdloc].column(1)