Run Code Only if using Combobox

[PicoTTS]

Hi,

I have a combobox that populates based on a query. However, I have to be flexible and allow the user to also manually populate the field with whatever they want. I would like to have my combobox execute a line of code only if the user selects one of the items from the combobox list and do nothing they are entering things manually.

Is this possible?



Thanks in advance

[John_G]

That will be a bit complicated. First, the Limit To List property of the combo box will have to be set to "No". However, you can't set it to
"No" if the bound column of the combo box is not the same as the first visible column. For example, if the combo box displays a department Name, but the bound column of the combo box is a (hidden) department number, then you can't set the Limit to List to "No".

If your combo box meets those criteria and you set limit to list to "No", then you can use the After Update event and the ListIndex property of the combo box to determine whether or not an existing row was selected.

If an existing value was selected, the value if listindex will be >= 0, otherwise it will be -1. So in the After Update event, you could put:

If comboboxname.listindex >= 0 then
'.... an existing row was selected, so do something
endif

[PicoTTS]

Perfect. That did the trick. Thanks