Greetings to the well of knowledge...
Newbie to the forum, pretty fluent in Access development.
But I've a bit of a dilemma.
Using Access 2010. My tables are stored in SQL Server and are linked within the Access app.
My DB consists of these tables:
tblPeople
tblPeopleClients
tblPeopleFamily
tblPeopleDonors
frmPeople
frmPeopleClients
frmPeopleFamily
frmPeopleDonors
tblPeople consists of basic information about individuals we do business with in the organization. Each person is assigned to one or more categories: Client, Family, and/or Donors. For each category the person belongs to, there is a Yes/No field in tblPeople (isClient, isFamily, isDonor) and a corresponding record in the appropriate PeopleCategory table.
frmPeople is, of course, the front-end form that shows all the basic information. Depending on the category (or categories) of the person, the appropriate PeopleCategory form is opened, and the contents specific to the user are displayed.
In frmPeople, I use a Combo box which users can employ to show only the subset of People he wants to see. I use Me.Filter in VBA to set criteria based on whether Clients, Family, or Donors is chosen.
Pretty straightforward so far, but here's the rub...
Each person classified as a client can be subcategorized as using one or more services: Residential, Day, Vocational, and Transport. The data for these are stored as Yes/No fields in tblPeopleClients and are displayed in frmPeopleClients.
I would like to add a second combo box on the main form, frmPeople, so that when the user select "Clients" from the first box, the second combo appears and allows the user to select a service. This was easy to code.
Building the filter to affect this, however, has me stymied because my focus is in the main form, frmPeople, but the subcategory is displayed in frmPeopleClients, which does not have focus. I cannot fathom how I can create a filter in VBA that essentially says, for example, show me records where frmPeople.isClient = TRUE and frmPeopleClients.IsResidential = TRUE. Because frmPeople has the focus, it doesn't "see" frmPeopleClients as a valid part of the filter criteria.
God, I hope I explained that well enough. Can I do what I want to do here?
Regards,
Ken
Newbie to the forum, pretty fluent in Access development.
But I've a bit of a dilemma.
Using Access 2010. My tables are stored in SQL Server and are linked within the Access app.
My DB consists of these tables:
tblPeople
tblPeopleClients
tblPeopleFamily
tblPeopleDonors
frmPeople
frmPeopleClients
frmPeopleFamily
frmPeopleDonors
tblPeople consists of basic information about individuals we do business with in the organization. Each person is assigned to one or more categories: Client, Family, and/or Donors. For each category the person belongs to, there is a Yes/No field in tblPeople (isClient, isFamily, isDonor) and a corresponding record in the appropriate PeopleCategory table.
frmPeople is, of course, the front-end form that shows all the basic information. Depending on the category (or categories) of the person, the appropriate PeopleCategory form is opened, and the contents specific to the user are displayed.
In frmPeople, I use a Combo box which users can employ to show only the subset of People he wants to see. I use Me.Filter in VBA to set criteria based on whether Clients, Family, or Donors is chosen.
Pretty straightforward so far, but here's the rub...
Each person classified as a client can be subcategorized as using one or more services: Residential, Day, Vocational, and Transport. The data for these are stored as Yes/No fields in tblPeopleClients and are displayed in frmPeopleClients.
I would like to add a second combo box on the main form, frmPeople, so that when the user select "Clients" from the first box, the second combo appears and allows the user to select a service. This was easy to code.
Building the filter to affect this, however, has me stymied because my focus is in the main form, frmPeople, but the subcategory is displayed in frmPeopleClients, which does not have focus. I cannot fathom how I can create a filter in VBA that essentially says, for example, show me records where frmPeople.isClient = TRUE and frmPeopleClients.IsResidential = TRUE. Because frmPeople has the focus, it doesn't "see" frmPeopleClients as a valid part of the filter criteria.
God, I hope I explained that well enough. Can I do what I want to do here?
Regards,
Ken
