jjc9809
asked on
Access 2007 Order Database Question
Hi everone,
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.
jjc9809
TradeShow-NEW-.accdb
Please find my attached database for review. When the user selects Vendor/Store Number with the mouse and selects the Product/Price/QtyAvailable
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
Any help is appreciated.
jjc9809
TradeShow-NEW-.accdb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.