Hi everyone
Need help with something...
I have an unbound form that saves records. What I want to know is if it's possible to be able to directly view the record in a report once I've clicked save? The reason for this is because I do daily reports and my database helps keep records should my managers request a quarterly report or specific date. Once I click save, I want to view the record and export it to pdf to email them the report.
My save button VBA gives me a confirmation message once the record is saved but if I can add something directly after for e.g. "Would you like to view the report?" (Yes/No) and if I click yes, it will open the report to that specific record.
Need help with something...
I have an unbound form that saves records. What I want to know is if it's possible to be able to directly view the record in a report once I've clicked save? The reason for this is because I do daily reports and my database helps keep records should my managers request a quarterly report or specific date. Once I click save, I want to view the record and export it to pdf to email them the report.
My save button VBA gives me a confirmation message once the record is saved but if I can add something directly after for e.g. "Would you like to view the report?" (Yes/No) and if I click yes, it will open the report to that specific record.