Hi Jerry, My apologies to all the group members. I am not acustomed to writing replies on Yahoo e-mail. It keeps sending out the reply when I try to tab for a paragraph indentation. I will try to finish this and remember not to peck the tab key. 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 linked records can be added to the form as needed for a primary form record, 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 for the primary table and "many" is for 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 example file HERITAGE.MDB is developed in MS_ACCESS 97. It works in later versions by converting it when the database is opened in any version of Access. This is only a very brief outline of the process you seem to need. Please let me know if this is the kind of thing you need for your project. I might be help with more details if needed. Gene Fleming
--- On Tue, 6/23/09, Jerry Lundquist <[email protected]> wrote: From: Jerry Lundquist <[email protected]> Subject: [ms_access] Getting Popup Form to Only Show Records for Current Main Form Record To: [email protected] 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]
