Edit a record with a macro attached to a button

[reubendayal]

Hi All,



This is a basic question that I have been trying to find a solution for but nothing has worked so far.

I have created a form with a custom format to arrange the form fields to look like a report (to manage my casework). Anyway, I have a basic conditional formatting rule that highlights each case (lined up in a row of all fields) if that case was last last modified more than 3 days ago. And I've created another field that with the same data repeating for each case and have made it look like a button. Now I am trying to assign a 'On Click' event to it that would simply edit the respective Date-Modified field to today's date.

But I've tried linking that button to an expression builder function and tried a few macro options too..but am unsuccessful.

Please can you suggest what can be a simple macro to use when I click the button on that specific case that would simply edit the Date-Modified field to todays date.

Secondly, I would like to create just one dedicated button and attach a Macro to it to turn on/off the Conditional Formatting rule.

Any suggestions will be greatly appreciated.

Thanks
Reuben

[ranman256]

the on click code:

txtBox = Date()

[reubendayal]

Thanks ranman256.

I used the SetValue macro instead and used it correctly this time! So it worked.