You could put all the possible choices in a Select Case statement:

sql = "SELECT FormName FROM Forms"
rs.open sql, cnn

If Not rs.eof Then
   Select Case rs!FormName
   Case "Form1"
      Form1.Open
   Case "Form2"
      Form2.Open
   Case "Form3"
      Form3.Open
   ...
   End Select
End If

It's not pretty but it work.

HTH

>Is it possible to store the name of a form in a database (Access) and then somehow call that form to show.
>
>Example
>
>sql = "SELECT FormName FROM Forms "
>
>rs.open sql, cnn
>
>If Not rs.eof Then
> rs!FormName.Open
>End If
>
>I realize this code doesn't work but I wanted to give an example of what I am trying to accomplish. Is something like this possible?