get a reference on a form by using form's name

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to use a form name as a parameter to use it when this form is
opened to recalculate it from another (modal) form. I have just the one modul
form. But, to be recalculated forms can be different. This is why I'd like to
get a reference to know which one is opened.
Dim strFormName As String
Private Sub Form_Load()

strFormName = Trim(Me.Name)

fnFormName(strFormName)

End Sub

But, how is it possibleto get the reference on that to be recalculated form?
In the modal form something like the following:
[Forms]![& strFormName &].Recalc - unfortunately, it's not working

Thanks
 
Thanks, Mr. B.

But, it says "Microsoft Office Access can't find field ... (which is the
form name) reffered to your expression". So, it thinks it a field not a form
name.


Mr B said:
Try:

Form(strFormName).Requery

hth

Mr. B

Alex said:
I'm trying to use a form name as a parameter to use it when this form is
opened to recalculate it from another (modal) form. I have just the one modul
form. But, to be recalculated forms can be different. This is why I'd like to
get a reference to know which one is opened.
Dim strFormName As String
Private Sub Form_Load()

strFormName = Trim(Me.Name)

fnFormName(strFormName)

End Sub

But, how is it possibleto get the reference on that to be recalculated form?
In the modal form something like the following:
[Forms]![& strFormName &].Recalc - unfortunately, it's not working

Thanks
Click to expand...
Click to expand...
 
Thanks, Mr. B.

But, it says "Microsoft Office Access can't find field ... (which is the
form name) reffered to your expression". So, it thinks it a field not a form
name.
Click to expand...

I think Mr. B. meant to say Forms(strFormName) - not Form().

John W. Vinson[MVP]
 
Thanks, John,

Yes, that is exactly what I meant to say.

Sorry, Alex, I'll try to be more careful with my typing.

Mr. B
 
Any reason why you don't use

me


"me" is always the current forms ref

so

me.requery
 
Back
Top