Hey all,
I have an inventory management app that accepts data in batch from a barcode scanner. The batched scanner records are displayed on a form with Default View of Continuous Forms. The app requires a user to review the scanner data for any inconsistencies that may come across (easier than validating the data on the scanner itself) and mark records as valid. Valid records are then copied to the main Transaction table.
What I would like to do is to mark records with invalid data (perhaps an invalid Product ID or Bin Location) by changing the background color of the respective controls when the form opens as a way of drawing the user's attention to the problem areas.
Most of the methods I've tried so far apply the background color change to all records. I imagine this is the nature of using Continuous Forms. Is there a way to single out an individual record on such a form and just update the Back Color property of one of its controls?
Thanks,
Dave
I have an inventory management app that accepts data in batch from a barcode scanner. The batched scanner records are displayed on a form with Default View of Continuous Forms. The app requires a user to review the scanner data for any inconsistencies that may come across (easier than validating the data on the scanner itself) and mark records as valid. Valid records are then copied to the main Transaction table.
What I would like to do is to mark records with invalid data (perhaps an invalid Product ID or Bin Location) by changing the background color of the respective controls when the form opens as a way of drawing the user's attention to the problem areas.
Most of the methods I've tried so far apply the background color change to all records. I imagine this is the nature of using Continuous Forms. Is there a way to single out an individual record on such a form and just update the Back Color property of one of its controls?
Thanks,
Dave
