pass one string value as a form's name to call a form's method??
Posted on 2003-10-30
Hi! All experts,
I stored forms' names (frmFormName1, frmFormName2,...etc.) in a string field in a table.
I'd like to pass one string value as a form's name to call a form's method (ex: Load frmFormName), or change a form's property??
Is there any way to do that? Please advise!! Thanks in advance!!
Below are my codes:
Dim vStr As Variant
Dim vFrm As Form
Dim FormRS As New ADODB.Recordset
Dim FormSQL, vSys As String
'codes to get a string value from table
vStr = trim(FormRS!FormName) 'i.e."frmABC"
Set vFrm = vStr
'succeed if form name hard coded, but not I want.
Set vFrm = frmABC