By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,490 Members | 896 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,490 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.