More Help with Forms and output file path

[Michael]

I got this to work great thanks to you guys:

="c:\" & [Forms]![frm_rebate_vendor]![vendor_name] & [Forms]![frm_rebate_main]![combo5].[column](1) & " Rebate Report" & ".xls"

Now what I would like to do is use a form value to select the directory for the file as well. Such as:

="c:\" &forms!frm_rebate_vendor!vendor_name &"\" &[Forms]![frm_rebate_vendor]![vendor_name] & [Forms]![frm_rebate_main]![combo5].[column](1) & " Rebate Report" & ".xls"

I guess I would really like to go ahead and put it a couple of levels down such as ="c:\my documents\rebates\" & forms!frm_rebate_vendor!vendor_name &"\" &[Forms]![frm_rebate_vendor]![vendor_name] & [Forms]![frm_rebate_main]![combo5].[column](1) & " Rebate Report" & ".xls"

Is this even possible?

 

[Nikos Yannacopoulos]

Michael,

It's definitely possible, but wouldn't it be simpler and faster to try it
straight away than post the question and wait for an answer?

Nikos

I got this to work great thanks to you guys:

="c:\" & [Forms]![frm_rebate_vendor]![vendor_name] &

[Forms]![frm_rebate_main]![combo5].[column](1) & " Rebate Report" & ".xls"

Now what I would like to do is use a form value to select the directory

for the file as well. Such as:

="c:\" &forms!frm_rebate_vendor!vendor_name &"\"

&[Forms]![frm_rebate_vendor]![vendor_name] &
[Forms]![frm_rebate_main]![combo5].[column](1) & " Rebate Report" & ".xls"

I guess I would really like to go ahead and put it a couple of levels down

such as ="c:\my documents\rebates\" & forms!frm_rebate_vendor!vendor_name
&"\" &[Forms]![frm_rebate_vendor]![vendor_name] &
[Forms]![frm_rebate_main]![combo5].[column](1) & " Rebate Report" & ".xls"