Subforms - Selecting a record and calling up a separate form

S

Stephen

I would like to know if the following is possible:

I have a form (Masterform A) and a subform (Subform B). In the subform
(Subform B), there are records summarized. (For ex, instead of showing all 19
fields, I only show 3 to
save space.)

I would like the user to be able to select a record in the subform datasheet
(Subform B), and select the record (Case id) in the subform by mouse click,
or double mouse click, to bring up the ENTIRE record up in another form
(Editform B). (I would have a separate form created for this).

So basically, I want to show a truncated record in the subform. When
the user double clicks or clicks the command button, I want my form to
appear that shows the entire record.

Masterform A that houses Subform B (relationship one-to-many)
Mouse click on Case id (automatic record number) in Subform B
Search for same Case id (unique number) and show record in Editform B

I hope I explained myself…. I'm stuck and can't figure it out...

Thanks
 
Top