Open a form from a variable name

[philbullock1223]

I need to add a value a the form field Notes from a public function... the issue is that the form I add it to can varry (and I have about 100 forms).

Public Function FormAdd(FormName As String)

DoCmd.OpenForm FormName, OpenArgs:=0
DoCmd.GoToRecord , , acNewRec
 
FName = "[FormName]" 
[Forms]!FName!Notes.Value = "Sample Notes" 'This is where I get the error

End Function

Any suggestions?

 

[pbaldy]

Try

Forms(FormName)!Notes.Value

 

[philbullock1223]

Brilliant!! Thanks!!!

 

[pbaldy]

No problemo! By the way, FName wouldn't have worked, as it's the literal string "[FormName]" .