Combo Box Problem

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

Guest

I have created a Database to store details of items that are rented out to the students on my University campus. The problem I have is that I dont know how to make items in my combox box appear blanked out/light grey and unavailable for selection once they have been selected once. Each item has a due date back in which should them make them available for selection.

Any ideas would very very much appreciate
 
There is no way to do this in the combo box's drop down. You can requery the
combo box to remove these items from being displayed, but it would be nice
for the user to know that the item is available, just out at the moment.
What would probably work better would be to use 2 visible columns in the
drop down, the second column would display availability. In the combo box's
BeforeUpdate event you would verify that the user didn't accidentally pick
one of the unavailable items.

--
Wayne Morgan
Microsoft Access MVP


Tim Harris said:
I have created a Database to store details of items that are rented out to
Click to expand...
the students on my University campus. The problem I have is that I dont
know how to make items in my combox box appear blanked out/light grey and
unavailable for selection once they have been selected once. Each item has
a due date back in which should them make them available for selection.
 
Back
Top