[AccessD] Listbox Issue - Selected Property or ListIndex persisting after requery

I have a DB that uses cascading listboxes to drill down State > County >
City > High School 

I use the AfterUpdate event to clear the listboxes

Private Sub List30_AfterUpdate()

Me!List32 = Null
Me!List32.Requery

Me!List34 = Null
Me!List34.Requery

End Sub

Glad I was able to help lessen your pain.

David Gibson


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bill Benson
Sent: Wednesday, March 12, 2014 4:28 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Listbox Issue - Selected Property or ListIndex
persisting after requery

Worked!


Thanks David.

Hanged if I get why!

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David A. GIbson
Sent: Wednesday, March 12, 2014 5:16 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Listbox Issue - Selected Property or ListIndex
persisting after requery

I have an example at work so it's air code .
Me! Listbox2=null
Me!Listbox2=requery

I can send you a solid example tomorrow.

David GIbson


Sent from up the creek...