Default to time???

  • Thread starter Thread starter Bill
  • Start date Start date
B

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
 
Bill said:
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
Click to expand...

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()
 
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
 
Back
Top