Referencing a form field in a VBA statement

[Historypaul]

I'm trying to simplify how this form works for future programming. I have a pull down to select the type, which also changes the subform so that it's formatted for the appropriate type. I have a second field that contains the subform name. I would like to refer to that subform name value in that text box in the "on load" event of the form so that I know it opens the correct subform each time. The "on load" event procedure I'm using is:

[/code]


Me.OpeningSashSubform.SourceObject = "&[Me].[SashForm]&"
[code]

In principle I think it works. I think my problem is just in my punctuation...

I'd appreciate any help.

[alcapps]

Me.OpeningSashSubform.SourceObject = " & [Me].[SashForm] & "

make sure there are spaces..

I don't understand your use of the form at this point.

on open event you should have a default value. then when a combo box is selected the appropriate form would be re-queryed.
maybe you can post an example form with basic data to help or at least an image of the form.

[Historypaul]

When I have spaces like you showed, I get a naming error as shown. I attached a picture trying to illustrate how I'm trying to make this form work.

[Historypaul]

alcapps - it was the on open event default value I'm trying define based on a cell value.

I decided to try doing it with a variable instead of trying to use the cell reference directly in the expression. It works fine now. Ended up looking like this.

Dim strSashForm As String
strSashForm = Me.SashForm
Me.OpeningSashSubform.SourceObject = strSashForm

Thanks very much for being quick to jump in and offer to help!

[alcapps]

try using the on open event to use your code.

on open event .. not load plus after update of your text box..sashform
you don't need a string variable.

on open event of the form..
me.openingsashsubform.sourceObject = me.sashform
me.openingsashsubform.requery