Flag a line item even if it changes

[Tcurtis]

Good Morning. I have a table with list of parts that were checked out. In this list there are several status changes you can make, one of them being that the item was lost. I would like to be able to have a check box or other field populate when an item is put on the lost list and have the flag remain after the item is found and updated to found. How can I keep the flag as lost if the item is updated?

Thanks

 

[xenou]

Hi, not particularly easy *unless* you have a form-driven application and the *only* way to set a lost flag is to use the appropriate form (gui). Even then, you probably need a second field "ItemHasBeenLost" or "ItemWasLost" to go with your "Lost" field, and it should be updated to TRUE whenever the "Lost" field is updated to TRUE. In that case, you can use the Form's AfterUpdateEvent to check the Lost field.

Access 2013+ supports triggers but I do not have experience with that method. It may be another alternative.

A third alternative would be to use a nightly batch process to search for Lost items (which would be a satisfactory middle ground which would only fail for items that are lost, then found, in the same day).

 

[Tcurtis]

Thanks for the help. I reread my request and found that I was not very clear, which usually happens with me. We have a clerk that is in charge of changing the status of a part according to what they find. They have a drop down box that they use to change the status. Once the part is found, the status will change to a different status. Can I make the "Itemhasbeenlost" field stay that way after the part was found? I want to track all items that were lost and then found. The permanently lost items stay in this category so they are easy to track. Thanks

 

[xenou]

You would need another field to track that with. Or dates to track changes in status, which would add complexity.