remove from list

  • Thread starter Thread starter Nick X
  • Start date Start date
N

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
 
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.
 
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.
 
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
 
Back
Top