Listbox selection lost after requery

[c_breemersch]

hi,

I have a listbox (multiselect: extended) in Access.
You can select one or more lines and view those more in detail in a new form.
When closing this form, the list is requeried, but then the selection gets lost.

The listbox used to be a multiselect : simple. Then there was no problem, the selection wasn't lost.

Any idea on how to keep my selection?

Thanks,
Christophe

 

[Guus2005]

do not requery.

why would you anyway?

HTH

 

[c_breemersch]

Hi,

The requery is necessary, because the user can select a line, open the item in a different form and change certain fields.
When he closes the form, the changes also need to be reflected in the listbox.

Christophe

 

[Guus2005]

Then you have to store the selected Id's in an array or other variable and restore them afterwards.

HTH