[AccessD] show last value in listbox

Hello,

thanks to all who responded.
With your help i must be no problem to solve this.

Pedro Janssen



----- Original Message ----- 
From: "Gustav Brock" <Gustav at cactus.dk>
To: <accessd at databaseadvisors.com>
Sent: Thursday, July 21, 2005 7:41 PM
Subject: Re: [AccessD] show last value in listbox


> Hi Pedro
> 
> Your listbox may not have settled at the OnCurrent event of the form.
> 
> Thus, create a textbox and set the controlsource to:
> 
>   =SetListboxLast()
> 
> and create this function in the code module of the form:
> 
> Private Function SetListboxLast()
> 
>   ' Set listbox lstDemo to the last entry.
> 
>   With Me!lstDemo
>     If IsNull(.Value) Then
>       .Value = .ItemData(.ListCount - 1)
>     End If
>   End With
>   
> End Function
> 
> Then, shortly after the form has opened, the listbox is set to its last
> value.
> This is for a single-select listbox.
> 
> /gustav
> 
> 
> >>> pedro at plex.nl 07/21 4:00 pm >>>
> Hello Group,
> 
> is it possible, when opening a listbox with a long list of values, it
> opens always with the first value. Is it possible to open with the last
> values.
> 
> Pedro Janssen
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
>