Combo Box Problem

[Teacher]

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

 

[Tim Ferguson]

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

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?

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