How can I get a combo box to display only pertinent data?

[lenderb]

I would like a combo box to display only pertinent data; for instance, if an employee has two cars, I would like the combo box to display only that employee's two cars, not all the cars on the list.

 

[ZmrAbdulla]

Look for Cascading comboBox/Listbox in these forums.

________________________________________
Zameer Abdulla
Visit Me
Hold your child's hand every chance you get.
A time will come when he or she won't let you.

 

[tina20]

I have one main form named "Order" and it's subform name "Order Detail" which list the items and the prices.

I would like to highlight all the items that have the price over $100 on the "Order Detail" subform.

Would you please show me how to do that? Thanks for all help.

 

[PHV]

Take a look at conditional formatting.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244