Using form and field names as variables

[mcucino]

Hello All, I am hoping this is an easy question but I tried some examples off google and didn't have much luck. I want to have multiple forms point to one form called "InsertItemF". Let's call one the these forms SourceFormF. InsertItemF populates a listbox from a variety of tables based on specific parameters. It concatenates a string that is inserted into the SourceFormF.



The code that opens InsertItemF from SourceFormF also populates two fields, SourceForm and SourceField on InsertItemF (these are referenced in the code below)

Private Sub InsertItem()
Dim SrcFrm As Form
Dim SrcFld As String


    Set SrcFrm = Forms(Me.SourceForm)
    SrcFld = Me.SourceField
    
    Forms!SrcFrm!SrcFld = " nz(Dsum('[MMYYYY " & Me.CalcTypeCombo.Column(1) & "]', '[" & Me.TableCombo & "]', 'ID = " & Me.LineItemList.Column(0) & "'),0)"
    
End Sub

And here's a visual (red circle is the button on SourceF that opens InsertItemF, blue circle is the form/field names that were inserted by the red circled button. In this example it should be SourceF instead of Iif):

[GinaWhipp]

Hmm, not sure I understand exactly what you are trying to do. However, it occurs to me you should be pointing to the Control Name which should pull the value of that Control.

[Missinglinq]

I've read this post a half dozen times, and like Gina, and probably the other 150+ members who have read it and not responded...I have no real idea of what you're trying to do, here!

Statements such as

...Using form and field names as variables...

...I want to have multiple forms point to one form...

simply makes no sense.

I suspect you'd be better off to tell us, in plain language, exactly what you're trying t to accomplish, leaving out technical terms.

Linq ;0)>