Retrieve data based on primary key selection on Form

[Neel]

I have a Form that has all the fields of my table,
including the Primary Key and the Foreign Key IDs as Combo
Boxes.

I would like the user to select a value of the primary key
from the combo box and retrieve and display data for that
primary key value. Once the user changes one of the field
values including a new value for the Foreign Key for that
primary key, I want to Update the underlying table.

Any help or link / cut-paste of a similar code that works
is a big help. I am pretty new to Access, hence any help
would be appreciated.

Neel.