I have the following query created within Access (qryClientNotActive)

SELECT person_history.person_history_key, client.client_key, client_site.client_site_key, client.company_name, client_site.id_code, [client].[company_name]+", "+[client_site].[id_code] AS Expr1, client.active, client_site.active
FROM client INNER JOIN ((person_history INNER JOIN person ON person_history.person_key = person.person_key) INNER JOIN client_site ON person_history.client_site_key = client_site.client_site_key) ON client.client_key = client_site.client_key;

I have a form, (frmProfile_person_history_subform) with a text box, whose visible = No, (txtClientNotActive). I need txtClientNotActive to be visible once client.active and client_site.active are set to No.

I'm thinking there should be a way to call a value in a query behind the scenes in VBA, but I cannot figure it out.

Thanks.

Is this query the record source for the form in question? If so, do you have checkboxes on the form for client.active and client_site.active (assuming they're of type yes/no)? If so, then assuming their names are chkClientActive and chkClientSiteActive, respectively:

__________________
Greg Serrano
Michigan Dept. of Environmental Quality
Air Quality Division