ItemData from a listbox

[eliotchs]

Hi,

I'm trying to select a form based on a listbox item value



if me.followup_list.itemdata(6) >21 then
DoCmd.OpenForm "search_followup", acNormal, DataMode:=acFormAdd
Forms!search_followup.ProviderUniqueRecord_ID = Me.Followup_list
else
DoCmd.OpenForm "search_followup2", acNormal, DataMode:=acFormAdd
Forms!search_followup.ProviderUniqueRecord_ID = Me.Followup_list
end if

this doesn't seem to pickup itemdata(6)

Thanks in advance
Joe

[pbaldy]

What is it you expect that to return? That would refer to the bound column in the 6th record in the listbox. I wonder if you're after the Column property?

me.followup_list.Column(6)

[eliotchs]

oooh.. bound column,
the bound coulmn is 0
Yes I need column property...

[eliotchs]

thank you!!
I changed it to if me.followup_list.column(6) >21 then...

worked great!!!

[pbaldy]

Excellent! Glad it worked for you.