You need to add it to the Forms collection:

Private Sub Command1_Click()
Dim x As Form

    Set x = Forms.Add("Form2")
    x.Show
End Sub

>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?
>
>Thanks Nichole