Using Output To command

L

Leslie Isaacs

Hello All

I want to use a series of Output To commands to create and save a series of
reports. Ideally I would like the file to be saved to the same location each
time, but with a filename that will include (at the end) the text that is
contained in a certain textbox on the current form (this text in fact refers
to the 'period' to which the report relates). Looking at the parameters of
the Output To command, I can specify a path and filename in the Output File
field, but this would obviously overwrite one with the next - hence I need
to assign different filenames.

I'm sure this must be possible, but cannot see how. I hope someone can help.

Many thanks
Leslie Isaacs
 
S

Steve Schapel

Leslie,

Something along these lines...
="C:\YourFolder\File" & [Forms]![NameOfForm]![NameOfTextbox & ".snp"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top