How to call a form name from a lookup table

[jtgarrison]

I have a database front end that stores variables based on what the user is doing. What I want to do is requery a form, but the form is being looked up from the table.

Ex.

Dim strFormName as String

strFormName=dlookup("FormName","tblCurrentValues")

if CurentProject.AllForms(strFormName).IsLoaded Then
    Forms!strFormName.Requery
...

When I run it, I get "...can't find the Form 'strFormName' referred to in a macro expression or Visual Basic Code.

Any ideas?

Thanks.

[gershwyn]

Try referring to the form with this notation instead:

Forms(strFormName).Requery

[jtgarrison]

Thanks!

Something so easy cost me a couple of hours searching...