Default Values/Forms/Macros?

[sivega]

I am trying to create a database where I can keep track of devices that have been lent out.



Table--> Device, DateIn, DateOut, Person

I have 2 forms: The first is a "check out" form where the information of the person and device are entered and the DateOut is defaulted to the current date.

The second form is a "check in" form where I have a drop down that finds the record of the devices that are currently checked out. Is there a way for the DateIn feild of the table be update with the current date after a certain event?

Thanks!

[pbaldy]

Me.DateIn = Date()