One other question please: When creating the combo box for the MemberID in the subform - it was based on the Member query and I noticed the dialog box that helps you add the combo box asked 'Choose a field that uniquely IDs the row. Which column in your combo box contains the value you want to store or use in your database?' Then the next screen asks, 'When you select a value in your combo box, what do you want MS Access to do?' And you chose, 'Store that value in this field: Member ID'. Aren't those 2 questions asking the same thing? If not, can you describe in detail what the difference is? Sorry. Thank you, again!

---

Reply from Alex Hedley:

Say you have a Query that brings in Tables that contain the same value in a Field, i.e. name you wouldn't want to store that as your ID field as how would Access know which Record to choose if it is a duplicate, you need to pick a unique value like an ID or a composite key.
Once you have that you still have a choice as to whether to store that value in your Table. You could choose another.