How to create a functio with a variable form name

[toine]

I want to make a function to update two fields on a form.
The function has to be used for different forms so I want the formname
to be a variable. How do I do that?
The fields 'gewijzigddoor' en 'gewijzigdop' are equal on all forms and
related tables


The function I made so far (in module1) is:

Function recordgewijzigd(formuliernaam As String)
'hier datum en naam worden hier gesaved
Forms!formuliernaam.gewijzigddoor = inlnaamid
Forms!formuliernaam.gewijzigdop = Date
End Function

I call the function with:
call recordgewijzigd("frmklaarzetten")


when I try the following:
forms! & formuliernaam & .gewijzigddoor=inlnaamid

Access says it's expecting an expression
How do I solve this problem?

Thnx in advance

 

[Douglas J. Steele]

Function recordgewijzigd(formuliernaam As String)
'hier datum en naam worden hier gesaved
Forms(formuliernaam).gewijzigddoor = inlnaamid
Forms(formuliernaam).gewijzigdop = Date
End Function

Note that the form whose name is being passed must be open for the function
to work: you'll get an error if it isn't open.

 

[toine]

I get indeed an error.
The function is called in the beforeupdate event of the form.
Is that the problem?

 

[Douglas J. Steele]

What's the error you get?

I'll repeat, the form whose name you're passing to the function as
formuliernaam must already be open before you call the function.