Hi,
I have a form called frmBillingExport. On that form i have a button called cmdExcel that when clicked exports all the records to excel.
On the form i have a sub-form called subfrmBillingExport and in that form there are lots of fields and one of them is a tick box called blnInvoiced. The subform is also in datasheet view.
Its also worth mentioning that the subform runs off a query that displays the values based on criteria provided on a previous form.
Anyway...
What i want to do is when you click cmdExcel I want a window to pop up to say "Are you sure you want to invoice all of these bookings?" with buttons for Yes and No. On the Yes click i want it to tick the blnInvoiced for all those records and then only export it so i assume take whatever code is suggested and place it before that export happens.
Grateful for the help!
Thanks
Wayne
I have a form called frmBillingExport. On that form i have a button called cmdExcel that when clicked exports all the records to excel.
On the form i have a sub-form called subfrmBillingExport and in that form there are lots of fields and one of them is a tick box called blnInvoiced. The subform is also in datasheet view.
Its also worth mentioning that the subform runs off a query that displays the values based on criteria provided on a previous form.
Anyway...
What i want to do is when you click cmdExcel I want a window to pop up to say "Are you sure you want to invoice all of these bookings?" with buttons for Yes and No. On the Yes click i want it to tick the blnInvoiced for all those records and then only export it so i assume take whatever code is suggested and place it before that export happens.
Grateful for the help!
Thanks
Wayne