Need an Update Macro

[ssworthi]

I have an Access 2007 simple db that I am building for a non Access user. I would like to do some of the data entry for him by having a macro or some process that when he selects a certain value in one field it populates another with a date. So in example if he selects "Bus 3" or "Bus 4" in the transportation field the date needed field would populate with 09/12/2010. This is way over my head but I would think there would be a way. Thanks so much for any help you can provide.

 

[Trevor G]

Just wondering did you get this sorted?

What would be required is behind the control on the form in the properties you would need to look at the Events Tab and then the After Update Event

You would have to select the elipses button on the right and select Code Builder, then you would have to write the code to tell it which field it is to add the date to and would it be todays date or something else?

The code you would add is something like this

me.datefieldname.value=Date

That would place todays date in the field

Let us know what you need.