Setting the first record in list box

J

John Dumay

Hi Folks,

i am trying to set the first record in a list box (no multiselect) but the
problem I have is that the list box items are created from a dynamic query
that fisrt looks up the values. How do i tell the list box that to select the
first record and to highlight this when the form is displayed?

As always your help is appreciated.

Regards,


John Dumay
 
P

Peter Doering

John said:
i am trying to set the first record in a list box (no multiselect) but the
problem I have is that the list box items are created from a dynamic query
that fisrt looks up the values. How do i tell the list box that to select the
first record and to highlight this when the form is displayed?
Click to expand...

Me!YourListBox = Me!YourListBox.ItemData(0)
 
D

daniel

John Dumay said:
Hi Folks,

i am trying to set the first record in a list box (no multiselect) but the
problem I have is that the list box items are created from a dynamic query
that fisrt looks up the values. How do i tell the list box that to select
the
first record and to highlight this when the form is displayed?

As always your help is appreciated.

Regards,


John Dumay
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using the list form control: multi-selection possible? 3
Unable to display values in 2nd list box from 1st list box selection 2
Limiting the number of selections in a List Box Control 5
Filter by form using a multiselect listbox 16
list or combo box 0
Combo or list box 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Journal 'Automatically record these items' is blank 0

Top