'Acess defaul value not puplulating and preventing data entry not matching other text box

I have a form/query, on click this form saves the data to a table and then a query is run updating the records. We use this to mark products that have been shipped as "shipped". I am having 2 issues.

  1. user enters DeID Base (Account) then the bag/box number, then the user needs to enter the the product shipped witch starts with the DeID + 4 numbers usually starting with 1001. I have the DeID and Box set to default = to the de ID base and box previously entered but the table does not populate the first records but does in the second. Screen shot in yellow.
  2. I want a pop up warning if the user enters one DeID but by accident scans a different product for a different customer. Like the DEID is 1001ABC and the user scans a product with code 1234ABC1001, which should be going to client 1234ABC. Example in screenshoot in blue.

Any help is greatly appreciatedenter image description here

enter image description here

default


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions