synchronizing forms and subforms 1

[kahoustex]

Need help/ideas/concepts for form design where Main form is "organizations", subform is "members". One organization to many members. User access needs to be by member not organization. Want to find/search/filter by member and sync main form so it shows organization info for that member and subform will display all members in organization. Skill level with Access bleak, db concepts strong. Old Paradox/DOS programmer having to start all over again with O.O.P. Thanks.

 

[elizabeth]

Here's a basic example:<br>
<br>
1. Create qry4frmOrg that contains all the fields from tblOrg that you'd like to see on the main form. Be sure to include the foreign key for Member. Create qry4frmMember with all fields you'd like to see in the subform.<br>
2. Set up qry4frmMember with prompt for criteria in the MemberName field, something like this: <br>
[Enter Member Name:]<br>
3. Create new form using the Form Wizard. Do *not* select table or query in the first step, leave it blank. In the second step, use the pulldown to select all the fields from both queries.<br>
4. After the form is created, you can redesign as you like. <br>
<br>
Note: You can make the Member foreign key field on the main form invisible and protected (Visible property = No, Enabled = No, Locked = Yes, Tab Stop = No) but it needs to be present for automatic linking.