Access 97 Forms

[Fierce]

I have a form with 3 pieces of information showing. I want to be able to type in a value in one control, and have the other two controls automatically update with the matching information. The control I want to change is the Primary key. Any help?? Thanks!

[constructor]

Generally you use a combo box to select the info you wish to show which contains say the personID and the Name.
You pick the name and using code in the after update property of the combo You insert a DoCmd FindRecord Me!

There are various ways to do this and I cannot fully explain here but you should be able to get sample code from some of the Access Forums.

Hope this helps