Using input box on form and external file copy

[chapm4]

I have and Access Database(97) That runs several queries, creates reports, and outputs to a directory as RTF files. You enter the date you wish to use in a text box. The output files then look like YY-MM-DD filename.rtf
based on current date minus 1. What I want to do for the future is use the YY-MM-DD that is in the text box. I also need to copy some rtf files from one server to another as a part of this process. I can do this using filecopy, but again I want to use my date info that is entered in the text box. So the question is how do I use the text box data? Say it is called txtBox1.

 

[SkipVought]

Hi,
UserForm1.txtBox1.Text is the value. Use it just like a variable. Skip,
metzgsk@voughtaircraft.com