belairbilly
Programmer
I have a selection criteria forms that selects a group of records based on parameters and displays the records individually on a different form. The user would like me to add a Print button to print the form as it looks on the screen but in a report format. I have seen some code that allows you to use Word and basically create formfields that are populated from the current record. The problem for me using that method is that template has to have a path in the module and I'm not sure how set that up using UNC mapping. Currently the example shows a standard harddrive path which is a pain to use. The Database resides on a server which could be designated as a different letter, depending on who is using it. The form that displays the records is fed by a recordsource that is dynamically created in code. Would like some recommendations on how to do this? Thanks