Combo Box Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need help with a problem that I have. My database holds information about items that are for hire. I want to make items that are selected from my combo box unavailable until they are returned from hire. My question is : - How do you make an item appear greyed out when it has been selected?

I would appreciate any help that anyone can give me!

Tim
 
I want to make items that are selected from my combo box unavailable
until they are returned from hire.
Click to expand...

Base the RowSource on a query that isolates the items that are still for
hire: I assume you'll need a join between Items and CurrentContracts or
something.
My question is : - How do you
make an item appear greyed out when it has been selected?
Click to expand...

A normal Access combo will not do this. You could use the solution above
just to make the unwanted items disappear; you could use a datasheet or
continuous subform with conditional formatting; or you could look for a
custom ActiveX control.

Hope that helps


Tim F
 
Back
Top