Date field generates when check box checked

[flhr0175]

Good morning,

In my table I want the date field to generate the current date when the check box is selected. I am not permitted to use VBA. They want it in datasheet view not as a form. When I click on the check box field in datasheet view and click on Table Tools -> Table -> After Update, I'm not sure what to do after that. I tried the "If" but only got as far as If me.[paforiginal]=true

it automatically adds "Then" but then I get another drop box to add a new action and don't know what to use.

Yes, I know this isn't the proper way to use Access but that is all they're allowing :banghead:

 

[Minty]

What version of Access is this - you can't do this at a table level normally. So "they're not allowing " might need to allow you.

If "they" are teaching you "they" aren't doing it very well. You don't edit data directly in forms.

 

[pbaldy]

I suspect you're being guided towards using a data macro? I think the next action would be SetValue or SetProperty.

 

[flhr0175]

I suspect you're being guided towards using a data macro? I think the next action would be SetValue or SetProperty.

Yes. the data macro isn't giving those options.

 

[pbaldy]

I haven't used data macros, but try EditRecord.

 

[sneuberg]

I've been playing with this for hours and I can't seem to get the AfterUpdate event to do anything. I suggest using the Before Change event. At least you'll be able to see something happen. I suggest watching the short video https://www.youtube.com/watch?v=bZRJF0ZykNU