remove from list

[Nick X]

Hi All,
I put a true/false (bit) field in my table called Remove so I could hide
items (table used for drop-down items). The problem is that this method
leaves the user with blanks if they want to look up historic items. The
question is can I remove Items from the combo box, but continue to display
them in the field?

Thanks,
Nick

 

[Douglas J. Steele]

I think I showed how to do this in my February, 2006 "Access Answers" column
in Pinnacle Publication's "Smart Access", but I'm not positive!

You can download the column (and sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html

 

[Arvin Meyer [MVP]]

Sure change the select statement on either the Combo use a textbox, placed
over the combo for existing records and bring the focus to the combo only
for new records.

 

[KARL DEWEY]

I use a 'work-around' by sorting on the true/false (displayed as 'Departed'
or some such) and then relevant fields in the drop down.

 

[Nick X]

Karl,
Thanks for your reply. Sorry, i think i misrepresented my question. I am
using the true false to Hide the items in the drop-down, but when that item
is hidden in the drop-down it does not show in the form (the form knows there
is something there because it will not filter as blanks). The field appears
to be blank in that particular record.

Thanks,
Nick