Open subform from List box

R

Ripper

I have a list box populated from a table called tblTardies.

The list box, lstTardyAdd, is on a form, frmTardyAdd. I want a subform to
open on the frmTardyAdd when I click on an item in lstTardyAdd. The subform
is different for most of the items in the list box.

Anyone have code for that?
 
O

Ofer

On the after update event of the list box you can enter the code

Select Case Me.lstTardyAdd
case 1 ' Enter the number of the Item on the list box
me.[SubFormNameOnTheForm].sourceobject="SubFormName1"
case 2
me.[SubFormNameOnTheForm].sourceobject="SubFormName2"
case else ' For any other item that doesn't apear on the case list
me.[SubFormNameOnTheForm].sourceobject="SubFormName3"
end select
 
Top