I have very little expiernce in MS Access. I currently use Access to keep up with my inventory. I have managed to edit the program slightly to fit my needs, but i am unable to do one thing that seems so simple.
I need an indicator to flash up when a part number has the same amount on hand as the minimum on hand level. I have managed to create a query that will give the information. I also can get the program to send up a message box, but it does this on every part number. I need to limit it to the part numbers where the two specific fields match. I am doing this with macros since I have no idea how to use Visual Basic.
Any help is greatly appreciated.