Okay. I’m a bit confused.
One user said it can’t be done, and another gave me the way to do it.
Assuming that User Name DPaxton is correct, and I can date a donation, how do I enter the code shown (ME!dateField=Now). Better yet, where do I enter this code? If you can’t already tell, I’m quite the novice at Access.
I think it comes down to whether you are updating the data from a form or directly from the table. It is better to use a form rather than letting users update the table directly. From the form, you have more control and less chance of someone inadvertlently messing up the info. So you need to set up a form that allows the user to select the correct record, then when the new data is input and accepted, not only does the data get updated, but have the form update the receipt date field also.
In the definition of the table the “DataField” must be defined as “Date”.
In a form that is used to update the donation an event is created. It can be either “AfterUpdate” of “AfterChange” or “OnExit”. You would enter the following code “Me!DateField = Now()”. This is done in “DesignView”. Click on the field that is going to be updated and then in “properties” find the “EventType” you want to do the date updating (“AfterUpdate” of “AfterChange” or “OnExit”.) then click on on the down arrow. Then click on [Event Procedure]. Next click on the box next to the down arrow (it has … in it). After that it will open “Microsoft Visual Basic” and place you where the code will need to be endered. After entering “Me!DateField = Now()” (without the “‘s) close the “Microsoft Visual Basic” .
Using after “AfterUpdate” or “AfterChange” each time the donation field (on the form) is updated or changed and you exit the field your date field will contain today’s date. If you use the “OnExit” as your event then each time you pass through the donation field (on the form) the date field would be changed.