Insert file (form) name in form

[gpbuckley]

I have a form in a database that is currently in development. The form will be used for basic data input. As bugs/issues are discovered the form will be up-revd each time (form name). Is there a way to have the cuurently opneed form name displayed in the form header section similar to the date which is currently dislayed?

Cheers

 

[SOS]

You can put a label there and in the form's open event put:

Me.YourLabelNameHere.Caption = Me.Name

 

[JamesMcS]

You could have a text box whose control source is me.form.name

 

[SOS]

You could have a text box whose control source is me.form.name

James - Me IS the form, so just Me.Name is the ticket.

 

[gpbuckley]

You can put a label there and in the form's open event put:

Me.YourLabelNameHere.Caption = Me.Name

Thanks for that - at the risk of appearing like a total clutz could you show me the syntax as I am not having any success. The form name is "general_rev2" and this is what I need displayed.

 

[SOS]

The syntax I gave you is EXACTLY the syntax you need:

Me.YourLabelNameHere.Caption = Me.Name

What is the name of the label on your form you want the name displayed on? All you need is to substitute YourLabelNameHere with the actual name of the label and the ME part is a programming shortcut which refers to the form itself. You don't need to change that at all. Me.Name returns the name of the form. You would put that line of code in your form's On Open event (in the VBA window and not the property dialog).