Set Forms Property

[ainow]

Is there a way to use passed parameters to set “Forms†property?

Private Sub SetFormsProperty(formName AS ???, fieldName AS ???)

Forms.formName.fieldName.Visible = True

End Sub

If yes what is the syntax and what type variables would formName and
fieldName be?

Thanks
Jim

 

[Douglas J. Steele]

Private Sub SetFormsProperty(formName AS String, fieldName AS String)

Forms(formName).Controls(fieldName).Visible = True


This will, of course, fail if the form isn't already open.

 

[ainow]

Doug

Thanks, that works.

Jim

Private Sub SetFormsProperty(formName AS String, fieldName AS String)

Forms(formName).Controls(fieldName).Visible = True


This will, of course, fail if the form isn't already open.