Checkbox to update Query

[Guest]

I have an interesting scenario in that the folks in Receiving make the first
entries as to a returned product. They enter an RMA number which could be
for one product or twenty five. They do this to help our tracking from when
a product actually enters the building. When they enter the RMA, the RXDate
auto fills along with their username. When they are finished entering, they
close their frontend. Later, the individual who works with returns, logs the
return, using a dropdown of the RMA's previously entered and completes the
rest of the info. I used a query to pull the RMA numbers, because our system
is based on a "Q" number, representing each individual product, which
autonumbers. This way several "Q" numbers could have the same RMA. The
problem I am facing is how to use a Checkbox or any other suggestions anyone
may have to mark an RMA as finished. When I've entered, say, all nine items
covered by the RMA, I don't want that number to remain on the dropdown. I am
using a table called RxEntry, with the following fields: RMANumber, RxDate,
ReceivedBy and RMAFinished (Checkbox). The Query is CboRMANumber with the
following fields: RMA Number, RxDate and RMAFinished with its criteria as
"No". Does any of this make sense??? Any ideas? Thanks!

 

[Guest]

I am assuming you must have all the nine items displayed in a form. If that
would be the case, then I would say you can write a code on next record to
see if all of the nine items have been taken care of. If yes, then write a
sql to update that particular RMA number for RMA finished to Yes.

Mike

 

[Ron2005]

Possible way, whether all nine are visible or not:

When you change the finish flag for one of them then in the afterupdate


if the finished flag is True then executes a Dcount for how many and a
Dcount for how many are finished. If the two counts are equal run a
query that sets the flag on the main one to finished.

And the flip side is if the finished flag is false then run a query
that sets the main one to False.

If you are using a query that has the main record flag as part of the
linked data then you can set it yourself without having a special query
to do it.

Ron