Data Entry

[coynesj]

I have a field in a form for the user to enter the name of a file. The fie will already be created in a specific location (C:\Desktop\) and be a specific file type (pdf)

I want to take this file name and devlop it into a set file path e.g. after the user enters "filename", somewhere in the data a file path is created C:\Desktop\"filename".pdf

Any suggestions on how to do this??

 

[JamesMcS]

You could just use a couple of variables - declare one for the user in put and one for the file path, then

Filepath = "C:\Desktop\" & Userinput & ".pdf"

 

[coynesj]

Thanks James, it makes perfect sense what you're saying but unfortunately I am still getting an error (#Name?)

Any suggestions??

 

[JamesMcS]

Ah - so it's a text box we're talking about? The error is because the control source is wrong. What have you got as the control source exactly?

 

[coynesj]

Thanks James, it makes perfect sense what you're saying but unfortunately I am still getting an error (#Name?)

Any suggestions??

Scratch that, I got it working...

Thanks again

 

[JamesMcS]

No worries....

 

[coynesj]

Ah - so it's a text box we're talking about? The error is because the control source is wrong. What have you got as the control source exactly?

That's it exactly what was needed....

I decided to try the control source after posting the original error.