Choose From List

  • Thread starter Thread starter Mary Fetsch
  • Start date Start date
M

Mary Fetsch

In Access 2000, let's say I have a combo box containing a list of states.
I'm looking for a way to know if the
user entered the characters "Florida" or if the user chose "Florida" from
the list. I'll appreciate any help anyone can give me.
 
Mary Fetsch said:
In Access 2000, let's say I have a combo box containing a list of states.
I'm looking for a way to know if the
user entered the characters "Florida" or if the user chose "Florida" from
the list. I'll appreciate any help anyone can give me.
Click to expand...

Other than capturing Keystrokes I'm not sure that there is any way to tell.
Can you explain why you need this?
 
Thanks for your response, Rick. The list in the combo box is a list of
various forms I call into a subform. Right now, if the user chooses from
the list, he/she then has to tab to get out of the field. It's not a big
deal, but I thought if there was a way I could figure out if the user chose
from the list, I'd do the tab for them.
 
Mary said:
In Access 2000, let's say I have a combo box containing a list of states.
I'm looking for a way to know if the
user entered the characters "Florida" or if the user chose "Florida" from
the list.
Click to expand...


Why on earth would you care how the item was selected?

You may be able to use the Change or KeyPress event to
detect typing, but, with AutoExpand on, a user doesn't have
to type the entire word to select from the list.
 
Mary,

Set the Limit To List property of the combobox to Yes and the user will only be
able to select a state. It should be simple to have a list of all the states so
Limit To List should be used anyway.
 
Mary Fetsch said:
Thanks for your response, Rick. The list in the combo box is a list of
various forms I call into a subform. Right now, if the user chooses from
the list, he/she then has to tab to get out of the field. It's not a big
deal, but I thought if there was a way I could figure out if the user chose
from the list, I'd do the tab for them.
Click to expand...

I still don't follow you. Are you using the AfterUpdate event? That should
fire when make an entry from the list (without having to Tab out). And anyway,
don't they currently have to Tab out when they type the entry?
 
Yes, they do have to Tab out or click somewhere after they type the entry
because that's the only way Access knows they're finished. However, when
they choose an entry from the list, the chances are high that they're
finished, so I'd like to take them out of the field after they choose. I am
using the After Update event, but that keeps them in the field after they've
chosen.

I'd still like to find a way to determine if the user's chosen from a list,
but for the form I'm using right now, I can set focus to the subform in the
After Update event.

Thanks for your time with this.
 
Back
Top