Full Version: Form With Two Listboxes With Selection Issue
UtterAccess Discussion Forums > Microsoft® Access > Access Reports
RubyB
I designed a form a while back with two list boxes. One contains vendor names & e-mail addresses (lstTo) and the other contains our company names & e-mail addresses (lstCc).

I select one or more from lstTo and one or more from lstCc, everything I select in both listboxes stays selected, I
press a button and the code in but button creates an e-mail in Outlook. Life is good.

I start a new database project, copy lstTo and lstCc from database1 into database2, all related code and I can click one or more in lstTo and one or more in lstCc.

I select one or more from lstTo, I click on a name in lstCc and my selections in lstTo get unselected. And back and forth, and back and forth.

Any suggestions of what sort of a setting didn't copy or something I've missed that would make selections in both listboxes release their selections in database 2. Database1 is cooperative; database2 is making me crazy.
RubyB
Oops, just found my solution. I had Me.Refresh on the lstCc_Enter event. Disabling that line fixed it.

Hope documenting such goofiness helps someone someday.

You never know.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.