Unselecting a row from listbox
I know this is probably a simple question but non the less the solution evades my research.
I have a list box filled with data. The user selects a row and the selection causes other fields to populate with data in the same form.
The question is, how do I allow the user to unselect the row selected by selecting the same row. The list box does not need to be changed to a simple select or multi select because the user can only select one row at a time. Also, I do not want a command button to unselect the value in the list box.
I have a list box filled with data. The user selects a row and the selection causes other fields to populate with data in the same form.
The question is, how do I allow the user to unselect the row selected by selecting the same row. The list box does not need to be changed to a simple select or multi select because the user can only select one row at a time. Also, I do not want a command button to unselect the value in the list box.
Last Comment
ASKER
Clicking on the selected item only works if the list box is either a simple or multi select. In this case I don't want to use either because this allows the user to select multiple rows.
I don't think that this can be possible.
An other solution that can serve your purpose.
Add an empty row in the listbox which user can select if he don't want to select any thing.
An other solution that can serve your purpose.
Add an empty row in the listbox which user can select if he don't want to select any thing.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
I knew it could be done. Thanks
Microsoft Access
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
to unselect, just click on the selected item...