Adding 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).

 

[Nick Coe \(UK\)]

Make the default value for your TimeStamp field Now(). This
is an Access function which returns the date and time from
your PC's system clock.

There is an example in Access Help.

--
Nick Coe (UK)
AccHelp v1.01 Access Application Help File Builder
http://www.alphacos.co.uk/ Download Free Copy

In James Fillmore via AccessMonster.com typed: