Data Validation for Combo Box Based on Query

[Ganymede]

I'm not sure if this is more of a form question than a query question.



I have a listbox on a form that allows the user to select one of several options from a query. But I want to make sure that the user only selects one of the options from the query results. I understand that the beforeupdate property can do this. But I'm not sure how to go about doing that.

[pbaldy]

From the sound of it, just make sure the multiselect property of the listbox is None.

[Ganymede]

I guess I could have tried that but I just made a "before update" if statement and that did the trick. Thanks though.

[pbaldy]

Less intuitive to me, but whatever works for you. As a user I might be annoyed if I was able to select more than one and then later got told I couldn't. That forces me to go back and unselect items to get back to one.

[Ganymede]

Less intuitive to me, but whatever works for you. As a user I might be annoyed if I was able to select more than one and then later got told I couldn't. That forces me to go back and unselect items to get back to one.

Where is the multiselect property? I've been looking all over for it

[pbaldy]

On the Other tab of the listbox properties.

[Ganymede]

On the Other tab of the listbox properties.

Odd. It's not appearing in the 2013 version.

Oh. I know what I did. I called it a listbox instead of a combobox. Sorry. It's a combobox. Doh!

Thank you though.