dropdown box

  • Thread starter Thread starter Susie
  • Start date Start date
S

Susie

I am using a dialog box with a dropdown to filter data for
a report. There are about 150 options and the data looks
like this (ex) "OPR-9121". The gals in data entry would
like to just type 9121 because they may not know the
preceding alpha characters and it is tedious to scroll
through 150 options to find what they are looking for. Is
there a way to put wildcards into the option box so this
would be possible? Thank you in advance for any help.
 
You could create a "dummy" code that means "I don't know". For example, if
you aren't using AAA you may want to add that to the list. You could then
filter on AAA to see if any were entered when the code wasn't known.
 
I don't think I communicated my problem effectively. The
gals aren't entering data, they are using the dropdown to
pick a division for the report which is like the "OPR-
9121". What I meant by "Type in", I meant that in the
dropdown option box, they would like to type in 9121 and
have OPR-9121 be the division that appears. You know how
when you start to type in an option box, the actual
options will begin to appear depending on what you are
typing. Is there a way to incorporate wildcards in the
option box so that when they would type 9121, OPR-9121
would appear in the option box? I hope this makes sense.
If not, we'll try again...

Thanks...
 
The combobox itself won't do this. You could turn off auto-complete then in
the Change event of the combobox do a search for the first match for what
they have typed in. Actually, in order to not interfere with what they are
typing, you would probably want to do the typing in a separate textbox and
have it manipulate the combobox. You could then leave auto-complete turned
on for them to use the combobox when they know the code and use the textbox
as a search when they don't.
 
Back
Top