Prev: niks
Next: LinkMasterFields Property error
From: Bisro Solan on 25 May 2010 13:30
I have a query (qryAssyReport) that has fields for approvals (Culus, FM, Ce).
The approval fields have image numbers in them so my label software knows
what to image to print. What I would like to do is have check boxes on the
report (rptAssyReport) for all the approvals that will set themselves to true
or false based on whether the approval field is null. Can anyone help with
this?
From: Arvin Meyer [MVP] on 25 May 2010 14:55
Reports have static data and should not respond to data on them except to do
calculations. You can check the values in a report and do an update query
from VBA code.

If the check boxes are not bound to data, the can be checked or unchecked
based upon a value in another control.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access
Co-author: "Access 2010 Solutions", published by Wiley


"Bisro Solan" <BisroSolan(a)discussions.microsoft.com> wrote in message
news:AE6FDBA5-F0B1-4592-8D67-07771A7D3050(a)microsoft.com...
>I have a query (qryAssyReport) that has fields for approvals (Culus, FM,
>Ce).
> The approval fields have image numbers in them so my label software knows
> what to image to print. What I would like to do is have check boxes on
> the
> report (rptAssyReport) for all the approvals that will set themselves to
> true
> or false based on whether the approval field is null. Can anyone help
> with
> this?


From: Maarkr on 25 May 2010 15:26
set your approval field to invisible and add a check box:
set the source to =IIF(IsNull([approval]), 0, -1)

"Bisro Solan" wrote:

> I have a query (qryAssyReport) that has fields for approvals (Culus, FM, Ce).
> The approval fields have image numbers in them so my label software knows
> what to image to print. What I would like to do is have check boxes on the
> report (rptAssyReport) for all the approvals that will set themselves to true
> or false based on whether the approval field is null. Can anyone help with
> this?
 | 
Pages: 1
Prev: niks
Next: LinkMasterFields Property error