Using name from filed as a report file name

[XP_2600]

I am exporting a report from access as rtf, i would like to get it named automatically based on a filed in table, is that possible? i tried to use export with formatting
output file:


there is option to build expression but it seems not working, is that possible or i must do it using vba ? thanks.

[ranman256]

it doesnt work that way.
you cant put variables in the macro, BUT you can in code.
instead of macro, use vb:

sub btnPrint_click()
vFile = "c:\folder\" & Format(date,"dd-mm-yyyy") & forms!myForm!PatientName & ".rtf"
docmd.OutputTo  acOutputReport ,"rptMyReport",acFormatRTF,vFile
end sub

[XP_2600]

it doesnt work that way.
you cant put variables in the macro, BUT you can in code.
instead of macro, use vb:

sub btnPrint_click()
vFile = "c:\folder\" & Format(date,"dd-mm-yyyy") & forms!myForm!PatientName & ".rtf"
docmd.OutputTo  acOutputReport ,"rptMyReport",acFormatRTF,vFile
end sub

Thank you its worked perfectly .