Adding Values to a combo box in form view

  • Thread starter Thread starter Mike H.
  • Start date Start date
M

Mike H.

Someone let me know if this is possible.

I have a street name field that has the user put the name
in the text field. I want to have this field work as a
combo box that updates the street names as new ones are
entered. I want to be able to select a street name from
the list, but if it is not there I want to type in the
street name and have it appear on the this in the
following entries. Hope that makes sense.

Any ideas?

Thanks.

Mike
 
Make sure that you set "Limit to List" to yes, then add
code to the "Not in List" event. There is actually
sample code in the Help for this. The main thing in the
Not in List event code is to set Response=acDataErrAdded.
 
Thanks for pointing me to that. Unfortunately I do not
have a great grasp on code so I do not know what
information in that example would be specific to my
database vs the example. Any help would be appreciated.

Thanks.

Mike
 
Ok I followed your web site and when I try to input
something other than what is in the list. Visual opens
and says
"Compile Error: Expect Variable or Procedure not Module"

Any ideas,

Mike
 
Back
Top