Loading List box

[savok]

Hi I am trying to load a list box with a Field and an Id

And need to later extract that ID.

Heres what I got so far

If Not objRec.EOF Then objRec.MoveFirst
Do While Not objRec.EOF
lstTitles.AddItem objRec!Job_Title
lstTitles.ItemData(lstTitles.NewIndex) = objRec!titleid
objRec.MoveNext
Loop

This adds the Job Title and TitleID as index I assume?

What I need to do is extract that titleid when the list box is clicked upon. Can anyone post the correct syntax plz. Thanks.

I tried these but it did not work, perhaps I am loading the index wrong? Any help would be great

MsgBox (lstTitles.ItemData(Index))
MsgBox (lstTitles.Index)

 

[savok]

plz really need the syntax for this, dont have my book with me lol

 

[SrikanthMc]

If Not objRec.EOF Then objRec.MoveFirst
Do While Not objRec.EOF
lstTitles.AddItem objRec!Job_Title
lstTitles.ItemData(lstTitles.NewIndex) = objRec!titleid
objRec.MoveNext
Loop



Here lsttitles is a listbox which has 2 list of values
1.Visible list with job_title column values
2.Invisible internal use list with titleid values

When the user clicks on the listbox then
lstTiles.Itemdata(lstTitles.selectedIndex) will return the titleid for the job_title clicked.

 

[savok]

thanks but I tried using that line before and got an error
////
Msgbox(lstTiles.Itemdata(lstTitles.selectedIndex))
////

It highlights the .selectedIndex and says Method or data member not found. Any ideas?

 

[savok]

never mind i got it now, thanks for the help

it was

lstTitles.ItemData(lstTitles.ListIndex)