JonathanAnon
Registered User.
- Local time
- Today, 19:04
- Joined
- Sep 21, 2007
- Messages
- 20
I have a database that keeps track of all of my calls. I am a field service engineer.
On the form, I have the name, address of client, cost, invoice number, callid and a few other fields. When I click the print invoice button, it opens a query based report which is an invoice related to the callid of the record that is open in the form.
BUT, if I change the cost field from say 500 to 600, when I click print invoice the report still opens with 500 as the cost. Only when I close out of the form after changing the cost, and then re-open the form and click print invoice will it update.
I have tried adding the command
docmd.save
to the print invoice buttons code (before the call to open the invoice report) but this does not work either. Any suggestions.
thanks,
Jonathan
On the form, I have the name, address of client, cost, invoice number, callid and a few other fields. When I click the print invoice button, it opens a query based report which is an invoice related to the callid of the record that is open in the form.
BUT, if I change the cost field from say 500 to 600, when I click print invoice the report still opens with 500 as the cost. Only when I close out of the form after changing the cost, and then re-open the form and click print invoice will it update.
I have tried adding the command
docmd.save
to the print invoice buttons code (before the call to open the invoice report) but this does not work either. Any suggestions.
thanks,
Jonathan
