My problem:
I have a form, which allows users to pick from a series of drop downs, when a user clicks the send button a report is called and a file C:\Temp\"&Filename & ".pdf" is created. Filename is "product" & userID,which is a global variable. Netscape composer is opened and C:\Temp\filename.pdf is identified as an attachment. The problem I am having is the report caption property must match the input parameter for filename. I need my report caption to be <product><userID>. I tried to put this in open report event and on activate, but the report is opened before it reaches the code. I originally had Product" in my report properties caption, it became more complicated when I had to add my global variable. Any suggestions as to how I could get my report caption and filename to match?