Setting the Default Value of List Box

[BW]

I have a form that has a listbox on it that list out customers of ours. It
is unbound and the bound column is the clientid field in my tblclients. I
have several unbound (6) boxes on this form that are also unbound and pull
up information using built in access functions such as dcount and dsum.
All of these boxes utilize the lstclients object to filter off of. The
issue is when I open this form it gives me the total for all clients in the
database even though I have set the default value of the listbox to 0. The
form works great as soon as a row is selected in the lstbox but I absolutely
don't want to show the totals for all clients to each of the program users
(Not to mention it takes several seconds to load this way). What is the
proper way to keep this from happing?

Thanks
Brent

 

[BW]

After reading my own post I guess my questions should be how do I get the
list box to automatically select the first record when the form loads?

Brent