Individual Record Subform

I am fairly new to access and I am wondering about a form.

In my form, I want to have certain field values displayed based upon which row the user selects.

So, pretend a user selects Row B, I want a subform that displays data from开发者_Python百科 only Row B.

Is this possible, and if so how? :)

Thanks!

---

You don't even need a subform for this.

Your main form is a continuous form and your data rows are displayed in the form's detail area, right?
If yes, you can just put bound textboxes in the form header or footer, and they will display the value of the selected row.

Here are some example screenshots I just made.
It's Access 2000 and it's in German (that's the only Access version that I have here), but you'll get the idea.

Design mode:

("Formularkopf" means "form header", and "Detailbereich" is "Detail" in English Access versions.)

At runtime:

Note that the textbox in the form header, which is bound to Field2, automatically displays the value of Field2 in the currently selected row.