discodave101
IS-IT--Management
I do an auto mailmerge that works fine when run in the back-end, yet as soon as I run the database securely the query parameter pops up asking for the value on the form, even though in the background the query has run and worked.
I have no idea why this is happening, anyone have any ideas?
More in depth:
I have a Form with a autonumber on it. When you click on button it opens query that displays info for that particular number i.e. forms!frmCVI!CVINo is in the query parameter. This query is linked to a mailmerge document that opens via a function that is triggered AFTER the query runs.
just to re-iterate the part thats stumping me, it works fine in the back end when i run it, but not after I've compiled it securely.
I have no idea why this is happening, anyone have any ideas?
More in depth:
I have a Form with a autonumber on it. When you click on button it opens query that displays info for that particular number i.e. forms!frmCVI!CVINo is in the query parameter. This query is linked to a mailmerge document that opens via a function that is triggered AFTER the query runs.
just to re-iterate the part thats stumping me, it works fine in the back end when i run it, but not after I've compiled it securely.