Dynamically Create Object Name

[George1111]

I think I have done this previously, but cant seem to lay my hands on how I did it.

I have a number of forms which are named frmOrd1, frmOrd2, frmOrd3 ...... frmOrd100

I need to be able to access any form randomly and would like to do something like this

THIS DOES NOT WORK BUT IS WHAT I WOULD LIKE TO DO

Key in a number   1-100 and allocate it to a variable   eg FormNumber

then ............  


FormName = "frmOrd" & FormNumber      'FormName might now be "frmOrd53"

Load FormName

[George1111]

I think I have done this previously, but cant seem to lay my hands on how I did it.

I have a number of forms which are named frmOrd1, frmOrd2, frmOrd3 ...... frmOrd100

I need to be able to access any form randomly and would like to do something like this

THIS DOES NOT WORK BUT IS WHAT I WOULD LIKE TO DO

Key in a number   1-100 and allocate it to a variable   eg FormNumber

then ............  


FormName = "frmOrd" & FormNumber      'FormName might now be "frmOrd53"

Load FormName

I have an answer to the problem by ahenry in VBForums !

    FormName = "frmOrd" & "02"
    
    Set NewForm = Forms.Add(FormName)

    NewForm.Show      ' Shows  frmOrd02