Insert file (form) name in form

gpbuckley

Gerry
Local time
Today, 23:44
Joined
Apr 8, 2010
Messages
16
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
 
You can put a label there and in the form's open event put:

Me.YourLabelNameHere.Caption = Me.Name
 
You could have a text box whose control source is me.form.name
 
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.
 
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).
 

Users who are viewing this thread

Back
Top Bottom