item selected in a listbox

  • Thread starter Thread starter SUZYQ
  • Start date Start date
S

SUZYQ

I have a multi-select listbox filled with error messages that a user
can select. For a few of the error messages I need to prompt for
additional information.

I'm using the click event of the listbox and then capturing
Me.lstSubType.Column(0). If it's one of the ones I'm interested in,
then at that point a InputBox prompts the user for information.

The problem that I'm having is that the user is prompted even if they
de-select the item.

How do I only prompt for the additional information when the item is
actually selected/highlighted?

Thanks!
 
Try putting your check/condition on the After Update event of the combo box
instead.

Hope this helps.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Cannot select items in listbox 1
Access Using DAO.Database VBA code to populate a listbox from another listbox selection 1
Selecting Listbox items in code 2
Deselecting items in a listbox 2
Delete Single item from multi select listbox 3
clear/remove highlight from selected items in listbox? 2
Listbox beforeupdate 2
Requery listbox 1

Back
Top