Query methods

M

Monty

The topic doesn't refer to typical Access "methods", say as a method
attached to or associated with a control.

I'm referring to ways of building a select query based on control
property values and how I might arrange them in a query.

I have some controls on a form that become enabled and disabled
depending on whther or not those controls have one or more date
values. For fields that have one value, the associated control
presents that value in a plain text box. For fields with mulitple
values, the associated control presents those values in a combo box.
The controls overlay one another and their appearance is control by
VBA statements turning on and off the respective control's 'enabled'
and 'visible' properties. The code is written so that no two overlaid
controls will be enabled at the same time.

However, on the form is a command button that runs a query based on
values displayed in this form. My problem occurs when the query must
decide which of the controls are enabled and which aren't.

Is there a way to determine in a query which controls are enabled?
That would be a good start.

Thanks
 
G

George Nicholson

Is there a way to determine in a query which controls are enabled?
No

Consider: add a new invisible "CurrentValue" control to the form. In the
code where you handle visibility and enabling issues, fill CurrentValue
appropriately. Point your query to CurrentValue.

or variation of the above, call your new control CurrentStatus. Fill it with
the enabled control name or tag as controls become enabled. Then incorporate
that information into your query via iff().

HTH,
 
Top