Single record in subform

[ShadyOne]

I have a database that I keep track of all of my PC inventory and endusers. I would like to know how (if possible) to choose a single record from a continous form that lists all of my users, and pull this record into a subform.

In otherwords if I click on a users record in a continous form, I would like a subform to open up with the selected record (and that record only)so that I can edit the record. How can this be accomplished?

Thanks in advance.

 

[BoroLee]

I have managed to do this previously.
I created a form with all the summary data on (i.e. Name of User, and also created a Command button on the form.
Also, create a form with all the other data on it which you would wish to edit.
Then create a macro with the OpenForm action.
Open the form with the data you wish to edit, and in the Where Condition field, select the field from that from whcih equals the field from the summary from.
This should do the trick.

 

[ShadyOne]

Thanks for the tip.

 

[dwinmtgy]

Unless I missed something this is an easy one. On your subform, go into design mode and edit the FORM properties. There are two that you should set. One is the "views allowed." Set it to "Single Form." Then on "Default View," do the same thing. Now when you open your form the subform will show one record at at time. Hope this helps.