combo box problems detecting null value

  • Thread starter Thread starter jonathan
  • Start date Start date
J

jonathan

Hi all,
I have a drop down field ona form which looks at a table. If i select an
item from the drop it runs an update query with the where clause in the
query comming from the selected drop down item. My problem is if i don't use
the drop and just type something else into the field (which they must be
able to do) it still runs the update query. What i need it to do is detect
if i a have selected an item from the drop down or not. If i don' then do
nothing else run my update query. hope some1 can help me with this.

cheeers in advance.
jon
 
I don't think that will work for him, as he said that users must be able to
type
somthing in.
Click to expand...

That's how a combo box works - by allowing the user to type in a value. Why do
you say that setting the "Limit To List" property to "Yes" won't work? Setting
the property merely limits the user's selection to an item in the list (whether
by typing the value or selecting the value with the mouse). If the user types in
a value that exists in the first visible column in the combo box, the selection
will be accepted - auto-expand (the default setting is "On") allows the user to
type a portion of an existing value and still generate a matching selection upon
pressing the Tab or Return key.
 
I see what you're saying, but the way that I read the original email was that the
user will may type something that is not in the box. He said "My problem is if i
don't use
the drop and just type something else into the field (which they must be
able to do)." The "something else" made me think that the user may type something
not in the box. I don't know why they would do this, but that's the way I read it.
Sorry for any confusion.

Kevin
 
Back
Top