Date stamp

[osp001]

Still pretty new to Access, so be gentle with me!

I have a table that has an item number, a quantity "in," a quantity "out," and a date column. The date column is new.

I'm trying to figure out a way to change the "date" field for each line as the quantity "in" is incremented. In other words, when a new item is added, the date field is updated.

I can get it to update when a *new* line is added, but I can't get it to update when that "in" field is incremented.

Any suggestions would be welcome. Thanks!

 

[TheAceMan1]

How are ya osp001 . . . . .

In the [blue]AfterUpdate[/blue] even of the "In" control:

[blue] Me!Date = Now()[/blue]

See Ya! . . . . . .