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