Updating values when report closes

[dkuntz]

My report is based on a query that displays all records that have a [SlotFlag] value of 1 for the previous day. After these are printed I want the [SlotFlag] value to be empty. Where would be the best place to code this? Also, would you use an IIF statement for this?

Thanks so much!!

Derek

 

[GlennL]

I have recently built something similar to this on a form.

I did it by creating an update query that alters *ALL* flags in the table back to False. (In a Yes/No field).

Then I built a macro that simly ran the update query. On my form I placed the Macro Name in the OnClick event procedure and it clears the table of any flags when the button is pressed.

In your case I should think that if you use the above method you would need to place the macro in the onclose event of your report.

[This message has been edited by GlennL (edited 05-28-2002).]