Ticking boxes with one button

[Simon]

When a cusomer requestes a brochure i enter there deatils intothe
system and tick a box to say brochrue requested

I then have a query/ form ( Continuous Forms) that dispays all the
customer that have requested a brochure. I then click a button that
prints out a brochure request letter


once this is done there is a tick box next to each customers details
on the form called Brochure Sent.


I then go throught all the customers and tick that a brochure has
been
sent


insteadof going throught and ticking each one i would like a button
that i can click and it will automacicaly tick Brochure sent box for
all the customers in qryBrochureRequests

 

[Perry]

I think you need to redesign a bit here:

The brochure request letter is a report?
If so, try to design one report in such a way that it can host the output of
one
query consisting of all customers (that need to be sent a brochure)

Once this is done, I would advise to make one button for the entire
operation.

First design a query that will pick up all customers that need to be sent
the brochure
Note: only those customers where [Brochure Sent] = False and [Send Brochure]
= True
This query is can be the one needed for the brochure report.
After the report is printed (all brochures for each customer), you need to
toggle the
[Brochure Sent] qualifier to True and [Send Brochure] one to False

All the above actions can be part of one single click.

So, try to design the above and kindly repost if you get stuck.

Krgrds,
Perry

 

[Larry Daugherty]

Hi Simon,

There are lots of ways to address the issues. One way I have used is
to have a field "Brochure Requested" in the master record.

On a switchboard I call the form to launch the print run. In the
Close Event of the Brochure Report is a message to the operator (You?)
asking of the entire run printed successfully. If You answer 'Yes"
then an update query is run that resets "Brochure Requested" in the
underlying table.

I don't know how much history you keep but I'd probably change the
above design such that the brochure request flag and the brochure sent
flags are date field types. That way you have a history.

Other issues will arise but their solutions will likely be evident;
subsequent requests, requests for multiple brochures, etc.

HTH