How do I use form_ ? 2

[dmaranan]

I'm trying to access a form with a space using the form_ method. I know I can do it with Forms!, but I need to know how to do it using the Form_ method. thanks!

 

[vb6novice]

Never heard of the Form_ method. Where are you getting that from?

 

[dmaranan]

I found the form_ method in a program that I'm customizing.

The following are equivalent:
Form_ApplicationEntry.firstname
Forms![ApplicationEntry.firstname]

 

[VBslammer]

That method works just like the Forms![myForm] method, but they are both limited to referencing forms that are already open.

You can create a new instance of a form using that syntax and reference it with a variable:

Sub OpenAssetsForm()
    Dim f As Form
    
    Set f = New Form_Assets    '<--normally used like this
    
    DoCmd.OpenForm f.Name
    
    Debug.Print &quot;Total Controls on Form &quot; & f.Name
    
    'Next 2 lines do the same thing.

    Debug.Print Form_Assets.Controls.Count
    Debug.Print f.Controls.Count
    
    DoCmd.Close acForm, Form_Assets.Name, acSaveNo
    
End Sub

VBSlammer

Unemployed in Houston, Texas

 

[Eupher]

dmaranan, I apologize for my reply to your post in the other thread. I was unaware that such a method existed for referring to forms.

But to get back to your question, I tried several variations on VBSlammer's suggestion, but was unable to find any way of referring to a form that has spaces in the name using the Form_ approach. Can you rename your form such that it has no spaces? VBSlammer, do you know of a way?

Ken S.

 

[VBslammer]

Just enclose the entire name in brackets:

[tt]

strCaption = [Form_Customers In Houston].Caption

[/tt]

VBSlammer

Unemployed in Houston, Texas

 

[Eupher]

Yes, VBSlammer, that works. A star for you.

Ken S.

 

[dmaranan]

Yes!!! thanks VBSlammer!