List Box Default Selection

#1 (**permalink**) 28-Jul-2006, 08:26 AM

I have a list box based on a query to display its values. When the user
opens the form, the list box requery's to get the values for the default
record on opening. Also on the form is a subform based on the users
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/12138-list-box-default-selection.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12138
selection in the list box. Is there any way that when the form is opened, i
can default the list box to have the first item in the list selected, so that
the subform displays this data for the first item in the list box, without
the user having to select it?

*

#2 (**permalink**) 28-Jul-2006, 08:26 AM

Set the Default Value property of the list box to:
=[MyListbox].[ItemData](0)

This assumes these properties for the list box:
Name MyListbox
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12138
Column Headings No
Multi Select No

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"BECAM" wrote in message
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12138
news:B2A028B0-E989-46FA-A3AD-6623E255D283@microsoft.com...
>I have a list box based on a query to display its values. When the user
> opens the form, the list box requery's to get the values for the default
> record on opening. Also on the form is a subform based on the users
> selection in the list box. Is there any way that when the form is opened,
> i
> can default the list box to have the first item in the list selected, so
> that
> the subform displays this data for the first item in the list box, without
> the user having to select it?