Beginning of Job1) What does BOJ mean?
Yes. Any form recordsource that wants to draw fields from members would need to have the is_availGlobal in its WHERE clause. Same for all the comboboxes.2) Is that RecordSource as referred to in the ManageSCATeam form available to the subforms, Members, Events, Assets, etc.? I am not sure how I would reference it elsewhere. Do I repeat that code in each ComboBox which selects members?
Didn't realize you wanted to differentiate in that manner. You need to select either Active or Inactive, but not both? In that case, ALL the selects need to have criteria for is_activeGlobal being either true or false.3) You say using the phrase "Select * from Members where Status = Is_ActiveGlobal" elsewhere when referencing the Members RecordSource. But doesn't that just select either Active members, or InActive members, rather than Active members or All members, as the Case statement does?
Same deal. The report recordsource needs the criteria.4) How do my reports that need to be sensitive to Is_Active relate to this?
Why did you have ELookups in the first place? For new records there's nothing to lookup. That's why we skipped it for the new records. If we make the fields bound, then do away with the dlookups and have the user just enter the dates in the first place. The Joined would never change, but the Resigned certainly could. Can that be blank until something needs to be there?5) I don't understand why my Joined and Resigned controls need to be unbound. I would like them to store into the members' profiles, so I don't have to do ELookUp()s everywhere I need to show their values. Is there something fundamentally wrong with doing that?