• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 329
  • 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.

jjc9809
TradeShow-NEW-.accdb
0
jjc9809
Asked:
jjc9809
1 Solution
 
peter57rCommented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

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