Adding New Record with Time Stamp

[James Fillmore via AccessMonster.com]

I'm creating a database for a community center. We want to keep a record
of the date and time when a member visits. So far, I have a table, Member,
that lists members name, and it is linked by MemberID to a table, TimeStamp
(with fields: MemberID, TimeStampID, Time Stamp). I want to make a form
that allows the member to select their name from a list box and click ok
(upon doing so, I hope to make a new record in TimeStamp with that members
MemberID and record the date and time in the Time Stamp field).

 

[Rob Oldfield]

Run the SQL append query in the after update event of the list box (though
that will write duplicate records if the user selects hte wrong list entry
first). You'd be better off grabbing network username ...

http://www.mvps.org/access/api/api0008.htm

...and using that instead of relying on the user making the right choice.
Would also mean that you could use a more sensible event then the after
update of a combo.