Count number of records in a listbox

[mrsbean]

I have several listboxes which are filled based on the selection which is made in the last listbox. When there is only one avalable option in the listbox, I want it to be automatically selected, and then to move on to the fill the next listbox which depends on its value. How can I do this?

MrsBean

 

[mrsbean]

Nevermind ... found it. Me.MyListBox.ListCount will count the records.

 

[mrsbean]

Me again ... that only answered part of my question. In the event that there is only one record in the listbox, how do I make it automatically selected?

 

[RoyVidar]

Try
[tt]if me!lstMyList.listcount = 1 then
me!lstMyList.selected(0)=true
end if[/tt]

If you're showing column heads, try
[tt]if me!lstMyList.listcount = 2 then
me!lstMyList.selected(1)=true
end if[/tt]

Roy-Vidar