OnNotInList

[Michael]

Instead of asking whether we want to add a value typed in a combo box that
is not in the list, is there possible to bring up a dialog box and let the
user browse for the required value?

 

[Ronald Dodge]

Yes, you can create a second form that then queries on the information,
which then let's the user select the value. It would also be advisable to
set this second form as a pop up modal form, which then you would use the
close action on the form to set the value in the primary form, should the
user have picked a value.

Once this form is created and ready to be used, you can call it up in the
OnNotInList Event.

 

[Michael]

Thanks, I'll try it out.

Yes, you can create a second form that then queries on the information,
which then let's the user select the value. It would also be advisable to
set this second form as a pop up modal form, which then you would use the
close action on the form to set the value in the primary form, should the
user have picked a value.

Once this form is created and ready to be used, you can call it up in the
OnNotInList Event.