File name command?

[fraser_lindsay]

Me again.

Can somebody tell me the command for inserting the current DB filename into a text box please. I can't find it anywhere.

Thanks

 

[wazz]

Dir(CurrentDb.Name)

 

[fraser_lindsay]

Thanks, but when I enter =Dir(CurrentDb.Name) into my 'control source' option fo rthe text box it automatically does this =Dir([CurrentDb].[Name])
and only shows #Name as the result.

What am I doing wrong?

 

[wazz]

is the textbox bound to a table or unbound? should be unbound. otherwise i'm not sure at the moment.

edit: er, that was kind of redundant. if you add that to the control source it makes it unbound, doesn't it...

 

[DCrake]

When you open the form on the OnLoad event use

Me.Textbox = Dir(CurrentDb.Name)


David