Limit to List

[BethB]

I have a drop down list which looks up values from a database (access). I
want my users to be able to either choose a value from the list or to type in
a new one which will dynamically update the database with a new record so it
shows up in the LOV next time the field is used.

Any Ideas are appreciated.

Thanks......Beth

 

[S.Y.M. Wong-A-Ton]

This functionality is difficult to achieve in InfoPath 2003 unless you use a
third party combo-box control that can also handle events.

If you're using InfoPath 2007 you can look into using the new 'combo box
control'. This allows you to type text into it. You can then add a 'Changed
event' to the combo box and write code to add the new record to the database.

 

[BethB]

I am using Infopath 2003 - (Cant update - corporate policy)
Okay if I cant update the table - I can live with that, but is it at least
possible to allow a user to choose from the LOV or freeform type into the
same control?

Thanks....Beth

 

[S.Y.M. Wong-A-Ton]

Like I said in my previous post, you'll need to purchase a third party
control or create an ActiveX control of your own to provide the functionality
desired.