Open a popup form with same record source as the subform it is actioned by

[Richard]

Thats a mouthfull of a title what I'm after should be really simple. I
have a form with a subform which itself has a subform the final
subform contains an individuals record. The individuals details will
not fit on the form so I would like to put a command button on it to
Open the individuals details up - I would like this Other form to be
Opened at the same record as the subform -

I use the form as a menu and the first subform is a family and the
second subform is the individual within a family.

I have not worked with subforms before and most of my program is
written in access as you can guess I am a beginner so be gentle.

Many thanks

[PC Datasheet]

Your subform is based on a table that has an unoque primary key for each record.
The form you want to open has to have records that contain that same field but
here it is called a foreign key. Your button needs to be on the subform and
needs the following code in the Click event:
DoCmd.OpenForm "NameOfPopUpForm",,"[NameOfForeignKeyField] = " &
Me!NameOfPrimaryKeyField

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Richard" <pc*******@hotmail.com> wrote in message
news:f6*************************@posting.google.co m...

Thats a mouthfull of a title what I'm after should be really simple. I
have a form with a subform which itself has a subform the final
subform contains an individuals record. The individuals details will
not fit on the form so I would like to put a command button on it to
Open the individuals details up - I would like this Other form to be
Opened at the same record as the subform -

I use the form as a menu and the first subform is a family and the
second subform is the individual within a family.

I have not worked with subforms before and most of my program is
written in access as you can guess I am a beginner so be gentle.

Many thanks