• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 324
  • Last Modified:

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.

1 Solution
For continuous forms you must use Conditional Formatting (on the Format ribbon or on right-click menu) to format individual controls.  You cannot do it in code.

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now