Use ListBox to Open Forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I floundered around on the message boards this afternoon trying to find a way
to open a form from a click in a list box. The list box is populated by a
table, tblFormOpen. the table has 3 fields, id, formname, and formTitle.

I set up the list box to show only the title and hold the name. What I
really want is for the teachers to click on the title of the form in the list
box and have the list box open the appropriate form.

Anyone know how I can do this?
 
On the double click of the list box you can write this code

docmd.openform me.[ListBox].column(0) ' depend where the form name is , if
it in the second field the you should put (1)

select FormName, formTitle... from
then the form name will be me.[ListBox].column(0)

select formTitle, FormName
then the form name will be me.[ListBox].column(1)
 
Back
Top