Please find my attached database for review. When the user selects Vendor/Store Number with the mouse and selects the Product/Price/QtyAvailable
with the mouse, I need the selected row to tunr "Red" when the AvailableQty for the product is "0". I also need the row to trun yellow when the QtyAvailable is >0 and <11. How can I do this with VBA code. The textBox unbound is know as Product.
I have the database allowing this but it is turning the entire background Red or Yellow based on the Qty Available. I do not wnat this. I want only the selected Product/Price/QtyAvailable
row to turn "Red" or "Yellow"
Any help is appreciated.