GUIDO22
Registered User.
- Local time
- Today, 11:27
- Joined
- Nov 2, 2003
- Messages
- 515
I have an invoice record incorporating an invoice line items sub-form. I have a prompt dialog that gives the user a choice to delete the current record (and its lineitem records).
What is the best way to do this? given that the record in view is the record that I may wish to delete?
I can build the appropriate SQL and call using DoCmd but which event should this be called from to avoid complications with screens updates/refresh etc.
Note : Presently, the prompt dialog referred to above, displays during validation of the invoice record - hence, the dialog prompt is a YesNo Messagebox in a VB subroutine called PromptForDeliveryCriteria()
Thanks
What is the best way to do this? given that the record in view is the record that I may wish to delete?
I can build the appropriate SQL and call using DoCmd but which event should this be called from to avoid complications with screens updates/refresh etc.
Note : Presently, the prompt dialog referred to above, displays during validation of the invoice record - hence, the dialog prompt is a YesNo Messagebox in a VB subroutine called PromptForDeliveryCriteria()
Thanks
