Hi Preston,
I am now able to open the form by selecting a value from ComboBox after including the below code. However the form that opens up doesn't show any records. Thanks for any possible help.
Private Sub Combo8_EventName()
If Combo8.Value = "Form1" Then
DoCmd.OpenForm "Form1", , , acFormAdd, , , stLinkCriteria
End If
End Sub