Retrieve data based on primary key selection on Form

N

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top