Filter cbo Only on Enter (?)

  • Thread starter Thread starter croy
  • Start date Start date
C

croy

In a Combobox (cbo1) on a subform, I'd like the cbo1 to show
whatever entries have been made, but on entering cbo1
(drop-down), I'd like to filter the list such that only
currently available items are available to chose from.

I've taken a few runs at it, but haven't gotten close.

Is this even possible?
 
I'm assuming you've got a need to display old items because your combo box
is bound to a field in your table, and you have records for items that are
no longer valid.

You might need to use a technique similar to what I discussed in my
February, 2006 "Access Answers" column in Pinnacle Publication's "Smart
Access". Have both a text box (to display the value for the bound field)
plus a combo box (to display only the currently available items), and
control which one is displayed.

You can download the column (and sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html
 
My solution is to add a field for old/archive items/employees and have record
source sort on old/archive and the item/employee. Display item/employee and
status (old/archive) during selection.
 
SELECT [Auditor].[Auditor], [Auditor].[Name],[Auditor].[Active] FROM
[Auditor] ORDER BY Active,Last
 
Back
Top