Working with listboxes

[systemx]

Hi all,

Hopefully a simple one.

I have a hidden listbox (lstDupCus) on my form that is used for validation purposes. 'lstDupCus' is populated based on a query and would typically have nothing in it.

I am having trouble handling values in the list box and was hoping someone could provide me with pointers on the following (in VBA)....

1. How to determine if the listbox is populated (not if the user has selected a value, but whether anything exists in the listbox)

2. How to reference a single row of data in the listbox (eg. row 3) so I can then do something with the data.

I'd really appreciate any pointers.

Thanks

Robert

EDIT: Have just found .listcount - so just question 2 if anyone can help. Cheers

 

[gemma-the-husky]

i would think if you want to examine a list of duplications (possibly errors therefore) an invisible list box is not the best place, and you would be better opening the query recordset, and examining it with code.