ammujr (MIS) Nov 18, 2003
Hi,
I was wondering if I could force a field in a report.
Let me explain, I have a report that is based off a query( Product survey letter). The query is set to ask me which sales order number, it then inserts the the relevant information into the letter for the customers (like there name, the sales order # , todays date).
There is a form that allows me to update and search through the list of Sales orders. I added a command button on the form that allows me to preview the Survey letter. But when i press the button it asks me to for the sales order number. I was wondering if I could force the report to use the sales order number that is already displayed on that form.
Thank you, I hope it makes sense
Hi,
I was wondering if I could force a field in a report.
Let me explain, I have a report that is based off a query( Product survey letter). The query is set to ask me which sales order number, it then inserts the the relevant information into the letter for the customers (like there name, the sales order # , todays date).
There is a form that allows me to update and search through the list of Sales orders. I added a command button on the form that allows me to preview the Survey letter. But when i press the button it asks me to for the sales order number. I was wondering if I could force the report to use the sales order number that is already displayed on that form.
Thank you, I hope it makes sense
