J
JohnE
Hello. There is a situation in which the table that is used for a combobox
is growing in the number of items. Some of the items are out dated and no
longer used. Those items are prefixed with 'zz' so they go to the bottom of
the list. Several items were deleted early on but when the record(s) these
are in no longer showed in the record. Which is why the 'zz' was added so
the items are still available and will show in the record.
What I am looking for is an alternative type of combobox that will show only
the active items (no 'zz' items) but when viewing a record with the item in
it will still show? Has anyone done such and if so, how?
I tried using a textbox, a button, and listbox making it all work similar to
a combobox. The only draw back is the textbox was locked which would not
allow the user to begin typing in the textbox and then begin a search.
Also, I was not able to get a validation if someone typed something in the
textbox it would need to be in the listbox or not allow it. Does anyone know
of an example how this can be done?
Thanks to any who responds.
.... John
is growing in the number of items. Some of the items are out dated and no
longer used. Those items are prefixed with 'zz' so they go to the bottom of
the list. Several items were deleted early on but when the record(s) these
are in no longer showed in the record. Which is why the 'zz' was added so
the items are still available and will show in the record.
What I am looking for is an alternative type of combobox that will show only
the active items (no 'zz' items) but when viewing a record with the item in
it will still show? Has anyone done such and if so, how?
I tried using a textbox, a button, and listbox making it all work similar to
a combobox. The only draw back is the textbox was locked which would not
allow the user to begin typing in the textbox and then begin a search.
Also, I was not able to get a validation if someone typed something in the
textbox it would need to be in the listbox or not allow it. Does anyone know
of an example how this can be done?
Thanks to any who responds.
.... John