Printable View
Hi. I've several comboboxs in my form, and i made a simple fuction that in case the user enters a value in the combobox, wich is not on the list it adds that value to the database. The problem is the database table has 3 values, and the user only inserts one(the value in the combobox). I was wondering if there is any kind of input prompt box in VB that allows the user to enter the missing values, or do i've to create a new form for this?
The InputBox returns a string.
You can use it and ask the user to enter in the missing fields separated by some special character, i.e. "," or ";" or whatever that won't be part of the input fields. After the user click OK on the inputbox, you grab the string and split it.
The other more "professional" approach is to build your own inputbox as you already said it.
If you want to use the InputBox method (not recommended) you must make sure to handle empty input as the user might click on cancel