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

Bill Benson vbacreations at gmail.com
Wed Mar 12 16:27:38 CDT 2014


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...

-------- Original message --------
From: Bill Benson <bensonforums at gmail.com> 
Date: 03/12/2014  3:44 PM  (GMT-06:00) 
To: 'Access Developers discussion and problem solving'
<accessd at databaseadvisors.com> 
Subject: [AccessD] Listbox Issue - Selected Property or ListIndex persisting
 	after requery 
 
I have written listbox that has Table/Query RowsourceType property.

I am trying to clear the selection in it by requery. It does not seem to be
working.

In particular, if the user has selected B out of 

A
B
C


Then when I change Rowsource = "" and requery, the listbox contents vanish,
but when I make the rowsource equal to what it was, the selected item is
still selected.

My concern about this is, what happens if B no longer exists, or the order
of items changes, since I do not have a primary key type data field in the
listbox.

I could switch to AddItem but that might be slower.

All I want to do is have nothing selected after a requery.

Pulling hair out.

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list