Form Value from other table

[pacman22]

Im trying to do a form to input data in a table that is 1:1 with another. I already put to show me the pk of the principal , so i can know to who im imputing the values, and aslo put to show me the names of the principal,here is the problem, the pk is showed in a combobox but the names dont refresh automatically,i have to press refresh to see the correct name . How can i do that? In this video show an example what i want http://youtu.be/xqv2L2HUMpE?t=6m16s



and here is mine


p/d: sorry for my english

[June7]

A form can enter/edit records for only one table. Is this form RecordSource including both tables?

If they have a 1:1 relationship why do you have two tables? I suspect this is not a normalized structure.

Why don't you use a multi-column combobox as demonstrated in http://www.datapigtechnologies.com/f...combobox3.html

[pacman22]

Thanks for the answer. Im using 1:1 otherwise the table will have like 50+ columns ,and is gonna be a mess, and also ,doing this, i can separate in topics . I will try that, didnt know about that. If dont work , well...if gonna be only one table .