Hello all! I have several fields in a query that I want to be able to click a button on my switchboard at the beginning of each month that will reset fields that I select back to 0 or to an empty string, such as Rent Paid and Date Rent Paid (set as currency and date/time).
I've attempted to set up a macro for this. I've set the macro name to Reset Month. I'm using SetValue for action and pointing it to the rent paid field in my tenants query. For the expression I'm using =0. I'm assuming for reseting the date you would use ="".
But basically I want to set a macro to reset the rent paid field and clear out the date on the date rent paid field. Can anybody help me?
Thanks!
David Somers
I've attempted to set up a macro for this. I've set the macro name to Reset Month. I'm using SetValue for action and pointing it to the rent paid field in my tenants query. For the expression I'm using =0. I'm assuming for reseting the date you would use ="".
But basically I want to set a macro to reset the rent paid field and clear out the date on the date rent paid field. Can anybody help me?
Thanks!
David Somers