Hi Jerry,
Based on your message, I believe you really mean "subform" instead of
"pop-up". In computer work it is important to have the terminology correct.
Admittedly, Microsoft does not make that easy. I could be incorrect about your
intent too. Looking in the MS Access Help under subforms may be of some help
to you.
Anyway, here goes the general explanation. You have probably dome some of
this already. Here are the general steps:
1. Open a database.
2. Create two separate tables in that database. One will be the primary
table with fields that will always be shown in a form to be created later. The
other table should have the fields needed for the 'pop-up' information. As
many records can be added to the form as needed, such as "Child" which is the
subform table of the primary form based on a "Household" table.
3. Establish a "one to many" relationship between the promary and subform
table. The "one" is the primary table and "many" is the subform table.
4. Create a form to display the tables and allow data entry.
A few years back I created such a database for our church record keeping.
The attached file HERITAGE.MDB
--- On Tue, 6/23/09, Jerry Lundquist <lou_z...@yahoo.com> wrote:
From: Jerry Lundquist <lou_z...@yahoo.com>
Subject: [ms_access] Getting Popup Form to Only Show Records for Current Main
Form Record
To: ms_access@yahoogroups.com
Date: Tuesday, June 23, 2009, 1:06 PM
I am trying to do a popup form that will only display the records for the
current record on the main form. Does anyone have some advice, as I am going in
circles to do this.
Thanks
Jerry
[Non-text portions of this message have been removed]
