Default to time???

[Bill]

Hi,,

I have a table with a default value =time$.

Problem is when I enter a new record the time value of the NEXT record
defaults to the time when that previous record is entered. Thus if there is
an entry some minutes or so later the value for that entry is wrong!!

Any thought on what I am doing wrong please??

Ta.
Bill

 

[Lynn Trapp]

Try changing your default value to Now() and, then, just display the time
portion of the field.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Rick Brandt]

Hi,,

I have a table with a default value =time$.

Problem is when I enter a new record the time value of the NEXT record
defaults to the time when that previous record is entered. Thus if
there is an entry some minutes or so later the value for that entry
is wrong!!
Any thought on what I am doing wrong please??

Ta.
Bill

That's how defaults work. They are populated the instant the "New" row is
painted on the screen.

Use a form (never use a table as an interface) and populate the field in the
BeforeUpdate event instead of using a default.

If Me.NewRecord Then Me!FieldName = Now()

 

[Bill]

Thanks.

FYI, I am using a form but the default is in the table. I understand what
you have suggested though and will do.

Thanks again.
Bill