I just created a new table 'testing':

lname

fname

mydate

with PK defined as lname fname

default for mydate is getdate() in SQL

Table view entry from Access works just fine (nothing is entered into mydate)...

quote:

--------------------------------------------------------------------------------

is referral_date editable by the user? When you have the default value of getdate() how come Access returns an empty field?

--------------------------------------------------------------------------------

OK, Frank, referral_date is not editable by the user. But...